Re: Weird NOT IN condition in SELECT (PostgreSQL - Mailing list pgsql-hackers

From Ferruccio Zamuner
Subject Re: Weird NOT IN condition in SELECT (PostgreSQL
Date
Msg-id 3551.82.84.219.196.1088003088.squirrel@www.diff.org
Whole thread Raw
In response to Re: Weird NOT IN condition in SELECT (PostgreSQL 7.4.3  (Richard Huxton <dev@archonet.com>)
List pgsql-hackers
Richard Huxton said:
> 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_copia from prestiti);
>>
>> but it doesn't give me any records at all.

>> CREATE TABLE prestiti (
>>     id_copia integer references copie(id)
>
>> CREATE TABLE testi_fermi_prenotati (
>>     id_copia integer NOT NULL references copie(id),
>
> Are you sure you don't have any null values in prestiti.id_copia?

Yes, there is a null value and it has not to be there.
Thank you.

Bye,                        \ferz


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: 7.5-dev, pg_dumpall, dollarquoting
Next
From: Peter Martini
Date:
Subject: BLOBs and a virtual file system