Tom Lane wrote: > 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 ...
It would be pretty strange to use those as a default --- I am not inclined to mention it in the release notes --- we don't mention every change, only significant ones. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster