Skip site navigation (1) Skip section navigation (2)

Re: null != null ???

From: Alvaro Herrera <alvherre(at)atentus(dot)com>
To: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
Cc: Fran Fabrizio <ffabrizio(at)mmrd(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: null != null ???
Date: 2001-10-26 22:48:49
Message-ID: Pine.LNX.4.33L2.0110261946550.6735-100000@aguila.protecne.cl (view raw or flat)
Thread:
Lists: 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[(at)]atentus(dot)com>)
"La virtud es el justo medio entre dos defectos" (Aristoteles)


In response to

pgsql-general by date

Next:From: Eric RidgeDate: 2001-10-26 23:27:01
Subject: Re: UNIQUE constraint violations and transactions
Previous:From: Alvaro HerreraDate: 2001-10-26 22:43:56
Subject: Re: UNIQUE constraint violations and transactions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group