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

thanx this was the problem : the null values ....

----- Original Message -----
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>
Sent: Monday, November 10, 2003 07:58 PM
Subject: Re: [GENERAL] SQL query not returning the value expected
!!!!!!!!!!!!!!!!!!

>
> 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.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org