Re: [GENERAL] using INTERSECT and UNION in IN clause

2000-08-22 Thread Jules Bean
On Tue, Aug 22, 2000 at 01:50:26PM +0400, Alex Guryanow wrote: > 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' intersec

[GENERAL] using INTERSECT and UNION in IN clause

2000-08-22 Thread Alex Guryanow
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 followin