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 Re: using INTERSECT and UNION in IN clause | 
| Список | 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 по дате отправления: