Re: BUG #4021: UUID NULL and not equal query failed

Поиск
Список
Период
Сортировка
От Yann ROBIN
Тема Re: BUG #4021: UUID NULL and not equal query failed
Дата
Msg-id 001401c881f4$b26313a0$17293ae0$@robin@withart.fr
обсуждение исходный текст
Ответ на Re: BUG #4021: UUID NULL and not equal query failed  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
Список pgsql-bugs
Thank you, you're right and I should have none !

-----Message d'origine-----
De=A0: pgsql-bugs-owner@postgresql.org
[mailto:pgsql-bugs-owner@postgresql.org] De la part de Heikki Linnakangas
Envoy=E9=A0: dimanche 9 mars 2008 15:24
=C0=A0: Yann ROBIN
Cc=A0: pgsql-bugs@postgresql.org
Objet=A0: Re: [BUGS] BUG #4021: UUID NULL and not equal query failed

Yann ROBIN wrote:
> So my conclusion is that the NOT EQUAL operator doesn't match how it
should
> the NULL value field.
> Is it a bug or a wanted behavior ?

It's normal behavior, required by SQL standard, and not specific to=20
UUIDs. See also=20
http://www.postgresql.org/docs/8.3/interactive/functions-comparison.html.


--=20
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

--=20
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

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

Предыдущее
От: "Heikki Linnakangas"
Дата:
Сообщение: Re: BUG #4021: UUID NULL and not equal query failed
Следующее
От: Tom Lane
Дата:
Сообщение: Re: setseed accepts bad seeds