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@sss.pgh.pa.us]
Sent: Thursday, November 08, 2001 10:35 PM
To: Tuckheng
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] "Relation does not exist" error
Tuckheng <Tuckheng@vads.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