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
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) |