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 1EB41D1B510
	for <pgsql-hackers-postgresql.org@localhost.postgresql.org>;
	Wed, 22 Oct 2003 04:04:34 +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 05909-10
	for <pgsql-hackers-postgresql.org@localhost.postgresql.org>;
	Wed, 22 Oct 2003 01:04:03 -0300 (ADT)
Received: from sss.pgh.pa.us (unknown [192.204.191.242])
	by svr1.postgresql.org (Postfix) with ESMTP id 0DBE2D1B52D
	for <pgsql-hackers@postgresql.org>;
	Wed, 22 Oct 2003 01:04:02 -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 h9M43wit008364;
	Wed, 22 Oct 2003 00:03:58 -0400 (EDT)
To: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Cc: Hackers <pgsql-hackers@postgresql.org>
Subject: Re: 7.4 compatibility question 
In-reply-to: <3F95E9AA.9070304@familyhealth.com.au> 
References: <3F95E9AA.9070304@familyhealth.com.au>
Comments: In-reply-to Christopher Kings-Lynne <chriskl@familyhealth.com.au>
	message dated "Wed, 22 Oct 2003 10:21:30 +0800"
Date: Wed, 22 Oct 2003 00:03:58 -0400
Message-ID: <8363.1066795438@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200310/1007
X-Sequence-Number: 45689

Christopher Kings-Lynne <chriskl@familyhealth.com.au> 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...

			regards, tom lane