Re: 7.4 compatibility question

Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
>>> Now that DEFAULT 'now' will not work in PostgreSQL 7.4,  will DEFAULT 
>>> 'infinity' and DEFAULT '-infinity' and the like stop working as well? 
>> 
>> No, because those values don't change over time.  The issue here is when
>> exactly does the default value get evaluated...

> Ah, of course - but what about 'yesterday' and 'tomorrow' - these should 
> also be mentioned in the release notes.

Good point ... not that I think anyone is actually using such a default
in the field, but the behavior did change ...
        regards, tom lane