SQL-Query error with PGSQL 6.5beta1 - Mailing list pgsql-sql

From Joerg Fischer
Subject SQL-Query error with PGSQL 6.5beta1
Date
Msg-id 372FEB66.68402589@zkm.de
Whole thread Raw
List 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
wheresubext 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


pgsql-sql by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: [HACKERS] pg_dump bug (was Re: [SQL] Slow Inserts Again)
Next
From: Greg Frith
Date:
Subject: User and Groups