Re: NULLS and User Input WAS Re: multimaster

From: PFC <lists(at)peufeu(dot)com>
To: "Andrew Sullivan" <ajs(at)crankycanuck(dot)ca>, pgsql-general(at)postgresql(dot)org
Subject: Re: NULLS and User Input WAS Re: multimaster
Date: 2007-06-04 16:17:43
Message-ID: op.ttenjtwtcigqcu@apollo13
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> Aaaargh! No, it doesn't. It means NULL. Nothing else.

Well, x = UNKNOWN doesn't make any sense... the answer is UNKNOWN.
x IS UNKNOWN does make sense, the answer is true or false. Replace
UNKNOWN with NULL...

Actually it means what the DBA wants it to mean (which opens the door to
many a misguided design...)

I hereby light a candle to the pgsql designers who didn't inflict
00-00-0000 00:00:00 upon us besides NULL dates.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message PFC 2007-06-04 16:41:06 Re: Numeric performances
Previous Message Teodor Sigaev 2007-06-04 16:00:50 Re: warm standby server stops doingcheckpointsafterawhile