Christopher Kings-Lynne <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]