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