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

Поиск
Список
Период
Сортировка
От Najib Abi Fadel
Тема Re: SQL query not returning the value expected !!!!!!!!!!!!!!!!!!
Дата
Msg-id 002d01c3a82c$6e1ede50$f664a8c0@nagib
обсуждение исходный текст
Ответ на SQL query not returning the value expected !!!!!!!!!!!!!!!!!!  ("Najib Abi Fadel" <nabifadel@usj.edu.lb>)
Список pgsql-general
thanx this was the problem : the null values ....

----- Original Message -----
From: "Stephan Szabo" <sszabo@megazone.bigpanda.com>
To: "Najib Abi Fadel" <nagib.abi-fadel@usj.edu.lb>
Cc: "generalpost" <pgsql-general@postgresql.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


В списке pgsql-general по дате отправления:

Предыдущее
От: "frank_lupo"
Дата:
Сообщение: Re: drop user question
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Problem with create index