Re: "IS NOT NULL" != "NOT NULL" - Mailing list pgsql-general

From Bruce Momjian
Subject Re: "IS NOT NULL" != "NOT NULL"
Date
Msg-id 200201200034.g0K0Ydl18925@candle.pha.pa.us
Whole thread Raw
In response to Re: "IS NOT NULL" != "NOT NULL"  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
> Another problem is that SQL's boolean operations act as though NULL
> is the logical value UNKNOWN, rather than explicitly setting up a
> boolean datatype with the three allowed values TRUE, FALSE, UNKNOWN.
> While the rules for propagation of NULL happen to be similar to the
> results that logic dictates you get for UNKNOWN, this is still a kind
> of type pun, and it doesn't help to reduce the confusion any.

Sorry for not mentioning section, it is Customizing Queries/Using NULL
values.  Content on the web:

    http://www.postgresql.org/docs/awbook.html

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Clarification question
Next
From: Bruce Momjian
Date:
Subject: Re: "IS NOT NULL" != "NOT NULL"