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

From: "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>
To: "Yann ROBIN" <yann(dot)robin(at)withart(dot)fr>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #4021: UUID NULL and not equal query failed
Date: 2008-03-09 14:23:59
Message-ID: 47D3F2FF.5010809@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Yann ROBIN 2008-03-09 14:48:54 Re: BUG #4021: UUID NULL and not equal query failed
Previous Message Yann ROBIN 2008-03-09 12:20:39 Re: BUG #3986: Error ts_vector with UTF8 WS2003