Re: NULL != text ?

From: Michael Glaesemann <grzm(at)myrealbox(dot)com>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: CSN <cool_screen_name90001(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: NULL != text ?
Date: 2005-10-20 06:57:41
Message-ID: 13C41E6D-879B-480D-A2F3-B2B002FA0FA2@myrealbox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2005-10-20 07:17:20 Re: Create GLOBAL TABLE
Previous Message Michael Glaesemann 2005-10-20 06:52:45 Re: PSQL suggested enhancement