On Mon, Feb 27, 2012 at 11:39:55AM +0000, anisim...@gmail.com wrote: > 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;
sure. it is so called "correlated subquery" and it's definitely not a bug. Best regards, depesz -- The best thing about modern society is how easy it is to avoid contact with it. http://depesz.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs