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.
Chris
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
