Re: NULL != text ?

On Oct 20, 2005, at 23:45 , Michael Fuhr wrote:

> On Thu, Oct 20, 2005 at 03:57:41PM +0900, Michael Glaesemann wrote:
>
>> 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?
>>
>
> IS DISTINCT FROM is defined in SQL:1999 and SQL:2003.

Thanks!

Michael Glaesemann
grzm myrealbox com