Re: NULL != text ? - Mailing list pgsql-general

From Michael Glaesemann
Subject Re: NULL != text ?
Date
Msg-id 13C41E6D-879B-480D-A2F3-B2B002FA0FA2@myrealbox.com
Whole thread Raw
In response to Re: NULL != text ?  (Michael Fuhr <mike@fuhr.org>)
Responses Re: NULL != text ?
List pgsql-general
On Oct 20, 2005, at 15:44 , Michael Fuhr wrote:

>   expression IS DISTINCT FROM expression
>
>   For non-null inputs this is the same as the <> operator.  However,
>   when both inputs are null it will return false, and when just one
>   input is null it will return true.  Thus it effectively acts as
>   though null were a normal data value, rather than "unknown".
>

Interesting! Thanks, Michael. You don't happen to know off the top of
your head if that's standard SQL, do you?

Michael Glaesemann
grzm myrealbox com




pgsql-general by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: PSQL suggested enhancement
Next
From: Richard Huxton
Date:
Subject: Re: Create GLOBAL TABLE