Re: null != null ??? - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: null != null ???
Date
Msg-id Pine.LNX.4.33L2.0110261946550.6735-100000@aguila.protecne.cl
Whole thread Raw
In response to Re: null != null ???  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
On Fri, 26 Oct 2001, Rich Shepard wrote:

> On Fri, 26 Oct 2001, Fran Fabrizio wrote:
>
> > I have a situation where the left and right side of a where clause both
> > evaluate to null independently, but when compared to
> > each other, they don't equate.  Observe:

Maybe you can do the comparison by doing

SELECT (blah) IS NULL AND (blah2) IS NULL;

If that's what you want.

--
Alvaro Herrera (<alvherre[@]atentus.com>)
"La virtud es el justo medio entre dos defectos" (Aristoteles)


pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: UNIQUE constraint violations and transactions
Next
From: Tom Lane
Date:
Subject: Re: Broken pipes