Thank you, you're right and I should have none ! -----Message d'origine----- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de Heikki Linnakangas Envoyé : dimanche 9 mars 2008 15:24 À : Yann ROBIN Cc : pgsql-bugs@postgresql.org Objet : 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 UUIDs. See also http://www.postgresql.org/docs/8.3/interactive/functions-comparison.html. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs