using INTERSECT and UNION in IN clause

Поиск
Список
Период
Сортировка
От Alex Guryanow
Тема using INTERSECT and UNION in IN clause
Дата
Msg-id 6585.000822@nlr.ru
обсуждение исходный текст
Ответы tip: weird parse error for pl/pgsql  (Keith Wong <keith@e-magine.com.au>)
Re: using INTERSECT and UNION in IN clause  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
Hi,

postgresql 7.0.2. Why by executing the following query

select * from magazine
where id in (     select mag_id from dict where word = 'akademie' intersect     select mag_id from dict where word =
'der'intersect     select mag_id from dict where word = 'klasse' )
 

I receive the following error:

ERROR: parse error at or near 'intersect'

while the query
     select mag_id from dict where word = 'akademie' intersect     select mag_id from dict where word = 'der' intersect
   select mag_id from dict where word = 'klasse' )
 

is executed successfully.

Is it possible to use INTERSECT and UNION keywords in subqueries?


Regards,
Alex




В списке pgsql-sql по дате отправления:

Предыдущее
От: Joerg Hessdoerfer
Дата:
Сообщение: Re: Continuous inserts...
Следующее
От: Keith Wong
Дата:
Сообщение: tip: weird parse error for pl/pgsql