Re: SQL query not returning the value expected !!!!!!!!!!!!!!!!!! - Mailing list pgsql-general

From Stephan Szabo
Subject Re: SQL query not returning the value expected !!!!!!!!!!!!!!!!!!
Date
Msg-id 20031110095749.P21795@megazone.bigpanda.com
Whole thread Raw
In response to SQL query not returning the value expected !!!!!!!!!!!!!!!!!!  ("Najib Abi Fadel" <nabifadel@usj.edu.lb>)
List 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.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Temp rows - is it possible?
Next
From: Christopher Murtagh
Date:
Subject: Two build problems - openssl and plperl on RedHat