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

2008-03-09 Thread Yann ROBIN
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

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

2008-03-09 Thread Heikki Linnakangas
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-c

[BUGS] BUG #4021: UUID NULL and not equal query failed

2008-03-09 Thread Yann ROBIN
The following bug has been logged online: Bug reference: 4021 Logged by: Yann ROBIN Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.0 build 140 Operating system: Windows XP SP2 Description:UUID NULL and not equal query failed Details: Hi, I've tried to do