Re: IS NULL seems to return false, even when parameter is NULL

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: IS NULL seems to return false, even when parameter is NULL
Date: 2008-10-20 12:26:04
Message-ID: 4998298961DE4098B1F0026AE0584E23@andrusnotebook
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Richard,

> Seems to work here:
>
> select (true or null) as a, (null or true) as b, (null or false) as c,
> (false or null) as d;
> a | b | c | d
> ---+---+---+---
> t | t | |
> (1 row)

I'm sorry for the wrong information.

Andrus.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-10-20 12:34:32 Re: IS NULL seems to return false, even when parameter is NULL
Previous Message Sam Mason 2008-10-20 11:40:12 Re: removing a portion of text