Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 6D0094761BC for ; Tue, 24 Sep 2002 11:27:53 -0400 (EDT) Received: from bucky.airstreamcomm.net (bucky.airstreamcomm.net [64.33.128.10]) by postgresql.org (Postfix) with ESMTP id AB27847614C for ; Tue, 24 Sep 2002 11:27:52 -0400 (EDT) Received: from hasler.dhh.gt.org (elk-ras1-cs-131.dial.airstreamcomm.net [64.33.137.133]) by bucky.airstreamcomm.net (Postfix) with ESMTP id 273ED12E92 for ; Tue, 24 Sep 2002 10:27:55 -0500 (CDT) Received: from [192.168.1.3] (helo=toncho.dhh.gt.org) by hasler.dhh.gt.org with esmtp (Exim 3.12 #1 (Debian)) id 17trah-0005Zb-00 for ; Tue, 24 Sep 2002 10:27:11 -0500 Received: from john by toncho.dhh.gt.org with local (Exim 3.36 #1 (Debian)) id 17traX-0004nm-00 for ; Tue, 24 Sep 2002 10:27:01 -0500 To: pgsql-sql@postgresql.org Subject: Re: [GENERAL] CURRENT_TIMESTAMP References: From: John Hasler Date: 24 Sep 2002 10:27:01 -0500 In-Reply-To: Message-ID: <87r8fj8l2y.fsf@toncho.dhh.gt.org> Lines: 14 User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.2 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/307 X-Sequence-Number: 9584 Josh Berkus writes: > now() or now('transaction') returns the transaction timestamp. > now('statement') returns the statement timestamp now('immediate') returns > the timestamp at the exact time the function is called. I like that. IMHO "the exact time the function is called" is what most people would expect to get from now(), but it's too late for that. -- John Hasler john@dhh.gt.org Dancing Horse Hill Elmwood, Wisconsin