thanx this was the problem : the null values .... ----- Original Message ----- From: "Stephan Szabo" <[EMAIL PROTECTED]> To: "Najib Abi Fadel" <[EMAIL PROTECTED]> Cc: "generalpost" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend