SQL-Query error with PGSQL 6.5beta1

Поиск
Список
Период
Сортировка
От Joerg Fischer
Тема SQL-Query error with PGSQL 6.5beta1
Дата
Msg-id 372FEB66.68402589@zkm.de
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Thomas Lockhart
Дата:
Сообщение: Re: [HACKERS] pg_dump bug (was Re: [SQL] Slow Inserts Again)
Следующее
От: Greg Frith
Дата:
Сообщение: User and Groups