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

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