using INTERSECT and UNION in IN clause

Поиск
Список
Период
Сортировка
От Alex Guryanow
Тема using INTERSECT and UNION in IN clause
Дата
Msg-id 7576.000822@nlr.ru
обсуждение исходный текст
Ответы Re: using INTERSECT and UNION in IN clause  (Jules Bean <jules@jellybean.co.uk>)
Список pgsql-general
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-general по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: Foreign Key Storage
Следующее
От: Jules Bean
Дата:
Сообщение: Re: using INTERSECT and UNION in IN clause