Re: Null Value Stored for Date e TimeStamp

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Null Value Stored for Date e TimeStamp
Дата
Msg-id 5299.1110779846@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Null Value Stored for Date e TimeStamp  (Fernando Ferreira <lfernando@pop.com.br>)
Список 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 по дате отправления:

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: [BUGS] We are not following the spec for HAVING without GROUP
Следующее
От: Neil Conway
Дата:
Сообщение: invalidating cached plans