Re: Null Value Stored for Date e TimeStamp - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Null Value Stored for Date e TimeStamp
Date
Msg-id 5299.1110779846@sss.pgh.pa.us
Whole thread Raw
In response to Null Value Stored for Date e TimeStamp  (Fernando Ferreira <lfernando@pop.com.br>)
List pgsql-hackers
Fernando Ferreira <lfernando@pop.com.br> writes:
> I would like know about the value stored for null value for fields date 
> and timestamp.

There isn't any; we don't store anything at all for a null.

I don't think those other DBs you mention equate a null to some
particular randomly chosen date, either.  You might be dealing with
some broken application software that uses such a thing as a way to
avoid dealing with true nulls ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: [BUGS] We are not following the spec for HAVING without GROUP
Next
From: Neil Conway
Date:
Subject: invalidating cached plans