SQL-Query error with PGSQL 6.5beta1

From: Joerg Fischer <fischer(at)zkm(dot)de>
To: PGSQL-SQL <pgsql-sql(at)postgreSQL(dot)org>
Subject: SQL-Query error with PGSQL 6.5beta1
Date: 1999-05-05 06:55:34
Message-ID: 372FEB66.68402589@zkm.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi!

If there is a separate beta mailing list for these kind of incidents, I
am sorry, but I could not find it.

Now, here is the problem. The following query fails with PGSQL 6.5beta1,
even though it seems correct:

select superext as name from OM_ExtendInheritance where subext in (
select superext as name from OM_ExtendInheritance where subext in (
select 'Patient' as name
)
union select 'Patient' as name
);

Postgresql reports:
ERROR: parser: parse error at or near "union"

Could there be a problem handling nested expressions?

Thank you!

Regards
Joerg Fischer

Browse pgsql-sql by date

  From Date Subject
Next Message Carlos Peralta Ramirez 1999-05-05 08:44:01 which guru know this ??
Previous Message Thomas Lockhart 1999-05-05 06:38:27 Re: [HACKERS] pg_dump bug (was Re: [SQL] Slow Inserts Again)