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

From: "Najib Abi Fadel" <nabifadel(at)usj(dot)edu(dot)lb>
To: "generalpost" <pgsql-general(at)postgresql(dot)org>
Subject: SQL query not returning the value expected !!!!!!!!!!!!!!!!!!
Date: 2003-11-10 08:30:05
Message-ID: 000e01c3a764$db174790$f664a8c0@nagib
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 ??????????????

dragon=> SELECT cod_etu from parcours_v where cod_etu = '043219';
cod_etu
---------
(0 rows)

dragon=> SELECT cod_etu from parcours_hors_cursus_v where cod_etu = '043219';
cod_etu
---------
043219
(1 row)

dragon=> SELECT cod_etu from parcours_hors_cursus_v where cod_etu ='043219' and cod_etu not in (select cod_etu from parcours_v);
cod_etu
---------
(0 rows)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message frank_lupo 2003-11-10 09:28:47 drop user question
Previous Message Mark Kirkwood 2003-11-10 07:49:03 Re: Recomended FS