Postgres Pro
Downloads
Home   >   mailing lists

Re: NULLS and User Input WAS Re: multimaster - Mailing list pgsql-general

From PFC
Subject Re: NULLS and User Input WAS Re: multimaster
Date
Msg-id op.ttenjtwtcigqcu@apollo13
Whole thread Raw
In response to Re: NULLS and User Input WAS Re: multimaster  (Andrew Sullivan <ajs@crankycanuck.ca>)
List pgsql-general
Tree view 
> 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.

pgsql-general by date:

Previous
From: Teodor Sigaev
Date:
Subject: Re: warm standby server stops doingcheckpointsafterawhile
Next
From: PFC
Date:
Subject: Re: Numeric performances