Re: "Relation does not exist" error

Hi,

Thanks a bundle. Applied your suggestion and it works :-)

Regards,
Tuck Heng
VADS BHD
03 - 7712 8330

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Thursday, November 08, 2001 10:35 PM
To: Tuckheng
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] "Relation does not exist" error

Tuckheng <Tuckheng(at)vads(dot)com> writes:
> I encountered this error when trying to run a SELECT statement from within
a
> Perl program. Would appreciate if someone could help shed some light on
what
> may be causing this or how it can be resolved.

ORDER BY on a UNION result can only refer to column names of the UNION
output columns. Lose the "p." and "s." in the ORDER BY and you'll be
fine.

regards, tom lane