Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #4021: UUID NULL and not equal query failed - Mailing list pgsql-bugs

From Heikki Linnakangas
Subject Re: BUG #4021: UUID NULL and not equal query failed
Date
Msg-id 47D3F2FF.5010809@enterprisedb.com
Whole thread Raw
In response to BUG #4021: UUID NULL and not equal query failed  ("Yann ROBIN" <yann.robin@withart.fr>)
Responses Re: BUG #4021: UUID NULL and not equal query failed
List pgsql-bugs
Tree view 
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 by date:

Previous
From: "Yann ROBIN"
Date:
Subject: Re: BUG #3986: Error ts_vector with UTF8 WS2003
Next
From: "Yann ROBIN"
Date:
Subject: Re: BUG #4021: UUID NULL and not equal query failed