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

From Yann ROBIN
Subject Re: BUG #4021: UUID NULL and not equal query failed
Date
Msg-id 001401c881f4$b26313a0$17293ae0$@robin@withart.fr
Whole thread Raw
In response to Re: BUG #4021: UUID NULL and not equal query failed  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
List 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 by date:

Previous
From: "Heikki Linnakangas"
Date:
Subject: Re: BUG #4021: UUID NULL and not equal query failed
Next
From: Tom Lane
Date:
Subject: Re: setseed accepts bad seeds