Re: IS NULL seems to return false, even when parameter is NULL - Mailing list pgsql-general

From Andrus
Subject Re: IS NULL seems to return false, even when parameter is NULL
Date
Msg-id 4998298961DE4098B1F0026AE0584E23@andrusnotebook
Whole thread Raw
In response to Re: IS NULL seems to return false, even when parameter is NULL  (Richard Huxton <dev@archonet.com>)
List 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.

pgsql-general by date:

Previous
From: Sam Mason
Date:
Subject: Re: removing a portion of text
Next
From: Tom Lane
Date:
Subject: Re: IS NULL seems to return false, even when parameter is NULL