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

Tom Lane wrote : > Current releases don't handle UNION in sub-selects. 7.1 will. Thanks very much for this "fast as speed light" answer ! Is there an idea about the 7.1 release date ? Just to know if this is will be in weeks, months or years... Christophe.

[SQL] SELECT FROM t1 WHERE id IN (SELECT id FROM t2 UNION SELECT id FROM t3)

Hello, I've got a problem with UNION and SELECT IN I have a first table: CREATE TABLE products ( idProduct INT4, nameVARCHAR(32) ); and two others tables: CREATE TABLE orders ( id INT4, ts TIMESTAMP ); CREATE TABLE preorders ( id INT4, ts