Re: [HACKERS] Weird NOT IN condition in SELECT (PostgreSQL 7.4.3

2004-06-23 Thread Richard Huxton
Ferruccio Zamuner wrote: Hi, I've following select, and I expect to receive a single record as result from it: select c.id from copie as c where c.enum=46857 and c.condizio_prestito = 'A' and c.id not in (select id_copia from testi_fermi_prenotati) and c.id not in (select id_co

[HACKERS] Weird NOT IN condition in SELECT (PostgreSQL 7.4.3 and 7.4.2 tested)

2004-06-23 Thread Ferruccio Zamuner
Hi, I've following select, and I expect to receive a single record as result from it: select c.id from copie as c where c.enum=46857 and c.condizio_prestito = 'A' and c.id not in (select id_copia from testi_fermi_prenotati) and c.id not in (select id_copia from prestiti);