reva.d91@gmail.com writes:
> It is ignoring the invalid columns in subquery,Instead of throwing the error
> 'Column does not exist'.
> (eg):
> select * from emp where (empname,empid,empno) in(selec emname,emid,emno from
> em_details)
> Note:There is no emno in em_details table.
Maybe not, but if there is one in emp, then this query is legal per
SQL spec --- emno is an outer reference.
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs