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
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