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 EA617D1B510 for ; Wed, 22 Oct 2003 04:15:27 +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 05993-10 for ; Wed, 22 Oct 2003 01:14:56 -0300 (ADT) Received: from houston.familyhealth.com.au (fhnet.arach.net.au [203.22.197.21]) by svr1.postgresql.org (Postfix) with ESMTP id 39801D1B4FE for ; Wed, 22 Oct 2003 01:14:55 -0300 (ADT) Received: from familyhealth.com.au (work-40.internal [192.168.0.40]) by houston.familyhealth.com.au (8.12.9p1/8.12.9) with ESMTP id h9M4EroD004689; Wed, 22 Oct 2003 12:14:53 +0800 (WST) (envelope-from chriskl@familyhealth.com.au) Message-ID: <3F960533.4080004@familyhealth.com.au> Date: Wed, 22 Oct 2003 12:18:59 +0800 From: Christopher Kings-Lynne User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.5) Gecko/20031013 Thunderbird/0.3 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane Cc: Hackers Subject: Re: 7.4 compatibility question References: <3F95E9AA.9070304@familyhealth.com.au> <8363.1066795438@sss.pgh.pa.us> In-Reply-To: <8363.1066795438@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/1008 X-Sequence-Number: 45690 >>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