"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