The following bug has been logged on the website: Bug reference: 6490 Logged by: Timofey Anisimov Email address: anisim...@gmail.com PostgreSQL version: 9.1.2 Operating system: Linux Description:
SELECT * FROM table1 where col1 in (select col2 from table2) if col2 exist in table1 and not exist in table2 there will be no error and query output all rows from table1; -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs