"Jody Weissmann" <jody(at)ifi(dot)unizh(dot)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