Postgres Pro
Downloads
Home   >   mailing lists

Re: processing results from INTERSECT, UNION or EXCEPT - Mailing list pgsql-novice

From Tom Lane
Subject Re: processing results from INTERSECT, UNION or EXCEPT
Date
Msg-id 2320.976643866@sss.pgh.pa.us
Whole thread Raw
In response to processing results from INTERSECT, UNION or EXCEPT  ("Jody Weissmann" <jody@ifi.unizh.ch>)
List pgsql-novice
Tree view 
"Jody Weissmann" <jody@ifi.unizh.ch> writes:
> SELECT t1.id FROM t1 WHERE t1.id IN (SELECT t2.id FROM t2 INTERSECT
> SELECT t3.id FROM t3)

7.0.* doesn't support UNION/INTERSECT/EXCEPT in sub-selects.

> Is there any way to do this besides using a temporary table?

Use 7.1 ... now in beta ...

            regards, tom lane

pgsql-novice by date:

Previous
From: "Chr. Rossmanith"
Date:
Subject: foreign keys & pg_dump
Next
From: Sterling
Date:
Subject: What's this mean?