Re: NULLs ;-) - Mailing list pgsql-general

From Tom Lane
Subject Re: NULLs ;-)
Date
Msg-id 26616.1164676875@sss.pgh.pa.us
Whole thread Raw
In response to Re: NULLs ;-)  (Scott Ribe <scott_ribe@killerbytes.com>)
Responses Re: NULLs ;-)  (Scott Ribe <scott_ribe@killerbytes.com>)
List pgsql-general
Scott Ribe <scott_ribe@killerbytes.com> writes:
> Well, actually, it would be:
>  a = b or (a = b) is unknown
> But that certainly would more concise.

But

regression=# select (null = null) is unknown;
 ?column?
----------
 t
(1 row)

which I think is not what you wanted.

            regards, tom lane

pgsql-general by date:

Previous
From: Scott Ribe
Date:
Subject: Re: NULLs ;-)
Next
From: Glen Parker
Date:
Subject: Re: How to increace nightly backup speed