Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id AE10263234B for ; Sun, 18 Jul 2010 05:54:17 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 51217-03 for ; Sun, 18 Jul 2010 08:54:09 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from exprod7og101.obsmtp.com (exprod7og101.obsmtp.com [64.18.2.155]) by mail.postgresql.org (Postfix) with SMTP id F13E5632277 for ; Sun, 18 Jul 2010 05:54:09 -0300 (ADT) Received: from source ([209.85.215.176]) by exprod7ob101.postini.com ([64.18.6.12]) with SMTP ID DSNKTELBL8SIqoLpyIM4UwF8hPg1qMqkwMYr@postini.com; Sun, 18 Jul 2010 01:54:09 PDT Received: by eyg5 with SMTP id 5so869329eyg.21 for ; Sun, 18 Jul 2010 01:54:07 -0700 (PDT) Received: by 10.213.31.208 with SMTP id z16mr3222432ebc.10.1279443247150; Sun, 18 Jul 2010 01:54:07 -0700 (PDT) Received: from [192.168.1.117] (dsl-hkibrasgw2-ff7ac300-240.dhcp.inet.fi [88.195.122.240]) by mx.google.com with ESMTPS id v59sm35877180eeh.4.2010.07.18.01.54.06 (version=TLSv1/SSLv3 cipher=RC4-MD5); Sun, 18 Jul 2010 01:54:06 -0700 (PDT) Message-ID: <4C42C12D.4090403@enterprisedb.com> Date: Sun, 18 Jul 2010 11:54:05 +0300 From: Heikki Linnakangas User-Agent: Mozilla/5.0 (X11; U; Linux i686; fi-FI; rv:1.9.1.10) Gecko/20100619 Iceowl/1.0b1 Icedove/3.0.5 MIME-Version: 1.0 To: "A. Kretschmer" CC: pgsql-performance@postgresql.org Subject: Re: now() gives same time within the session References: <418EC9BD4D7125488CCAC5C7C559A24803A9D0@MS10.lsc.net> <20100712111500.GA14489@a-kretschmer.de> In-Reply-To: <20100712111500.GA14489@a-kretschmer.de> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-4.2 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_MED=-2.3 X-Spam-Level: X-Archive-Number: 201007/264 X-Sequence-Number: 39653 On 12/07/10 14:15, A. Kretschmer wrote: > Use timeofday() instead, now() returns the transaction starting time. timeofday() is a legacy function kept only for backwards-compatibility. It returns a string, which is quite awkward. Use clock_timestamp() instead. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com