Re: SQL query not returning the value expected !!!!!!!!!!!!!!!!!!

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Najib Abi Fadel <nagib(dot)abi-fadel(at)usj(dot)edu(dot)lb>
Cc: generalpost <pgsql-general(at)postgresql(dot)org>
Subject: Re: SQL query not returning the value expected !!!!!!!!!!!!!!!!!!
Date: 2003-11-10 17:58:55
Message-ID: 20031110095749.P21795@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Mon, 10 Nov 2003, Najib Abi Fadel wrote:

> Hi if you take a look at the following query's you can see that the
> third query should logically return 043219 but instead it's not
> returning any rows ?? What's happening ??????????????

Are there any NULLs in parcours_v.cod_etu? NOT IN works oddly when
combined with NULLs.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christopher Murtagh 2003-11-10 18:46:16 Two build problems - openssl and plperl on RedHat
Previous Message Tom Lane 2003-11-10 17:56:06 Re: Temp rows - is it possible?