pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
using 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