Re: [HACKERS] Correlated subselect in regression test

2005-06-08 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > The regression test file subselect.sql contains the following query under the > heading "Correlated subselects": > SELECT '' AS five, f1 AS "Correlated Field" > FROM SUBSELECT_TBL > WHERE (f1, f2) IN (SELECT f2, CAST(f3 AS int4) FROM SUBSELECT_TB

[HACKERS] Correlated subselect in regression test

2005-06-08 Thread Peter Eisentraut
The regression test file subselect.sql contains the following query under the heading "Correlated subselects": SELECT '' AS five, f1 AS "Correlated Field" FROM SUBSELECT_TBL WHERE (f1, f2) IN (SELECT f2, CAST(f3 AS int4) FROM SUBSELECT_TBL WHERE f3 IS NOT NULL); It has b