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

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: BUG #4021: UUID NULL and not equal query failed
Дата
Msg-id 47D3F2FF.5010809@enterprisedb.com
обсуждение исходный текст
Ответ на BUG #4021: UUID NULL and not equal query failed  ("Yann ROBIN" <yann.robin@withart.fr>)
Ответы Re: BUG #4021: UUID NULL and not equal query failed  ("Yann ROBIN" <yann.robin@withart.fr>)
Список pgsql-bugs
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
UUIDs. See also
http://www.postgresql.org/docs/8.3/interactive/functions-comparison.html.


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

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

Предыдущее
От: "Yann ROBIN"
Дата:
Сообщение: Re: BUG #3986: Error ts_vector with UTF8 WS2003
Следующее
От: "Yann ROBIN"
Дата:
Сообщение: Re: BUG #4021: UUID NULL and not equal query failed