Received: from candle.pha.pa.us (candle.navpoint.com [162.33.245.46]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fAE3wom68316; Tue, 13 Nov 2001 22:58:50 -0500 (EST) (envelope-from pgman@candle.pha.pa.us) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.10.1) id fAE3wmY23341; Tue, 13 Nov 2001 22:58:48 -0500 (EST) From: Bruce Momjian Message-Id: <200111140358.fAE3wmY23341@candle.pha.pa.us> Subject: Re: Use of 'now' In-Reply-To: <4638.1005706352@sss.pgh.pa.us> "from Tom Lane at Nov 13, 2001 09:52:32 pm" To: Tom Lane Date: Tue, 13 Nov 2001 22:58:48 -0500 (EST) CC: Thomas Lockhart , PostgreSQL-documentation , PostgreSQL-development X-Mailer: ELM [version 2.4ME+ PL90 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Archive-Number: 200111/29 X-Sequence-Number: 1102 > Bruce Momjian writes: > >> Nothing of interest anymore, since 'current' has been removed as of 7.2. > >> However, Thomas has yet to commit any docs updates for his recent > >> datetime-related changes ... including that one ... > > > Seems it is still in there somewhere: > > > test=> create table bb (x timestamp default 'current', y int); > > Hmm. It was *supposed* to be removed entirely, but possibly what > Thomas actually did was to continue to accept the keyword as equivalent > to 'now'. Thomas? [ CC'ing to hackers because this is getting into code problems. ] Here's another inconsistency that Tatsuo found: test=> create table ff (x time default 'current_timestamp'); ERROR: Bad time external representation 'current_timestamp' test=> create table ff (x time default 'current'); ERROR: Bad time external representation 'current' test=> create table ff (x time default 'now'); CREATE test=> select current_timestamp; timestamptz ------------------------------- 2001-11-13 22:49:50.607401-05 (1 row) You can default a time to now, but not to current or current_timestamp. I believe this is happening because current is implemented as special timezones in datetime.c and timestamp.c, and current_timestamp is implemented in gram.y, while 'now' is a function. Anyway, looks like confusion that should be fixed. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026