Hi, The 2 following statements don't give the same result. I expected the second ti give the exact same result as the first one. What am I missing?
development=> SELECT id FROM entrees except select entree_id from postes ORDER BY id desc; id ------ 3651 (1 row) development=> SELECT id FROM entrees WHERE id not in (select entree_id from postes) ORDER BY id desc; id ---- (0 rows) thanks in advance for the help. Raph -- Web database: http://www.myowndb.com Free Software Developers Meeting: http://www.fosdem.org -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
