pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedusing INTERSECT and UNION in IN clause
2+ messages / 2 participants
[nested] [flat]
* using INTERSECT and UNION in IN clause
@ 2000-08-22 10:03 Alex Guryanow <gav@nlr.ru>
2000-08-22 14:16 ` Re: using INTERSECT and UNION in IN clause Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: Alex Guryanow @ 2000-08-22 10:03 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: using INTERSECT and UNION in IN clause
2000-08-22 10:03 using INTERSECT and UNION in IN clause Alex Guryanow <gav@nlr.ru>
@ 2000-08-22 14:16 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2000-08-22 14:16 UTC (permalink / raw)
To: gav <gav@nlr.ru>; +Cc: pgsql-sql
Alex Guryanow <gav@nlr.ru> writes:
> Is it possible to use INTERSECT and UNION keywords in subqueries?
No, not at the moment. This is one of many things we hope to fix when
we redesign querytrees (currently planned for 7.2 cycle).
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2000-08-22 14:16 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-08-22 10:03 using INTERSECT and UNION in IN clause Alex Guryanow <gav@nlr.ru>
2000-08-22 14:16 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox