| From: | "Yann ROBIN" <yann(dot)robin(at)withart(dot)fr> |
|---|---|
| To: | <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: BUG #4021: UUID NULL and not equal query failed |
| Date: | 2008-03-09 14:48:54 |
| Message-ID: | 001401c881f4$b26313a0$17293ae0$@robin@withart.fr |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Thank you, you're right and I should have none !
-----Message d'origine-----
De : pgsql-bugs-owner(at)postgresql(dot)org
[mailto:pgsql-bugs-owner(at)postgresql(dot)org] De la part de Heikki Linnakangas
Envoyé : dimanche 9 mars 2008 15:24
À : Yann ROBIN
Cc : pgsql-bugs(at)postgresql(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Euler Taveira de Oliveira | 2008-03-10 02:08:36 | Re: [BUGS] BUG #3975: tsearch2 index should not bomb out of 1Mb limit |
| Previous Message | Heikki Linnakangas | 2008-03-09 14:23:59 | Re: BUG #4021: UUID NULL and not equal query failed |