Using intersect in subquery - Mailing list pgsql-sql

From Hamid Khoshnevis
Subject Using intersect in subquery
Date
Msg-id 001301bee913$5cc027e0$810a0a0a@local.dom
Whole thread Raw
List pgsql-sql
I have tried to use intersect in subquery causing the following error.
Please help!
ERROR:  parser: parse error at or near "intersect"


select * from Table1
where KeyField1 in
(select KeyField2 from Table2 where  somecondition
intersect
select KeyField3 from Table3  where somecondition);

(I believe) I am running PG 6.4.  The INTERSECT by itself works, but not in
a subquery.

Thanks!

hamid




pgsql-sql by date:

Previous
From: "Nathan Angelacos"
Date:
Subject: CASE statement causes unknown node type 723
Next
From: "Hamid Khoshnevis"
Date:
Subject: Using intersect in subquery