* Tom Lane (t...@sss.pgh.pa.us) wrote: > SELECT ... FROM a WHERE a.x IN (SELECT ... FROM b, srf(y) WHERE ...)
Actually, this appears to fail already, at least in 9.2.2:
=> select * from (values (1)) v(a) where v.a in (select x from (values (2))
v2(a),
-> generate_series(1,a) x);
ERROR: function expression in FROM cannot refer to other relations of same
query level
LINE 2: generate_series(1,a) x);
^
Unless it's something else that you were referring to...?
Thanks,
Stephen
signature.asc
Description: Digital signature
