X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id B2BD0D1B4ED for ; Wed, 22 Oct 2003 04:22:09 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 18243-04 for ; Wed, 22 Oct 2003 01:21:39 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 9B299D1B4EC for ; Wed, 22 Oct 2003 01:21:38 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.10/8.12.10) with ESMTP id h9M4LYit008469; Wed, 22 Oct 2003 00:21:34 -0400 (EDT) To: Christopher Kings-Lynne Cc: Hackers Subject: Re: 7.4 compatibility question In-reply-to: <3F960533.4080004@familyhealth.com.au> References: <3F95E9AA.9070304@familyhealth.com.au> <8363.1066795438@sss.pgh.pa.us> <3F960533.4080004@familyhealth.com.au> Comments: In-reply-to Christopher Kings-Lynne message dated "Wed, 22 Oct 2003 12:18:59 +0800" Date: Wed, 22 Oct 2003 00:21:34 -0400 Message-ID: <8468.1066796494@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/1009 X-Sequence-Number: 45691 Christopher Kings-Lynne 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