Re: SELECT FROM t1 WHERE id IN (SELECT id FROM t2 UNION SELECT id FROM t3)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Christophe Boyanique <cboyanique(at)formanet(dot)be>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: SELECT FROM t1 WHERE id IN (SELECT id FROM t2 UNION SELECT id FROM t3)
Date: 2000-11-10 16:35:38
Message-ID: 11647.973874138@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Christophe Boyanique <cboyanique(at)formanet(dot)be> writes:
> SELECT idProduct FROM products
> WHERE idProduct IN
> (SELECT id FROM orders WHERE ts>'2000-10-01 17:04:00'
> UNION SELECT id FROM preorders WHERE ts>'2000-10-01 17:04:00')
> ORDER by name;

> and I've got a parse error near UNION or SELECT depending of the

Current releases don't handle UNION in sub-selects. 7.1 will.

In the meantime, consider doing the UNION into a temp table and then
using that for the IN operator.

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Christophe Boyanique 2000-11-10 16:45:17 Re: SELECT FROM t1 WHERE id IN (SELECT id FROM t2 UNION SELECT id FROM t3)
Previous Message Christophe Boyanique 2000-11-10 16:25:55 SELECT FROM t1 WHERE id IN (SELECT id FROM t2 UNION SELECT id FROM t3)