Re: not null - trivial, unexpected behavior - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: not null - trivial, unexpected behavior
Date
Msg-id Pine.LNX.4.30.0106161820100.755-100000@peter.localdomain
Whole thread Raw
In response to Re: not null - trivial, unexpected behavior  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: not null - trivial, unexpected behavior
List pgsql-sql
I wrote:

[ x = NULL vs. x != NULL ]
> > What am i missing?  Shouldn't those two sets be complimentary?
>
> They should.

Correction:  Each Boolean expression can have one of *three* values: true,
false, unknown (null).  So those two sets will not be "complimentary" in
the traditional sense because both expressions _should_ (modulo the
information I pointed you to) return "unknown".

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: not null - trivial, unexpected behavior
Next
From: Stephan Szabo
Date:
Subject: Re: calling user defined function with parameters..