Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 0C6062E007A for ; Sat, 5 Apr 2008 14:47:01 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 75402-06 for ; Sat, 5 Apr 2008 14:46:28 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from smtp-out3.libero.it (smtp-out3.libero.it [212.52.84.43]) by developer.postgresql.org (Postfix) with ESMTP id 274332E0038 for ; Sat, 5 Apr 2008 14:46:56 -0300 (ADT) Received: from MailRelay10.libero.it (192.168.32.119) by smtp-out3.libero.it (7.3.120) id 4628C87A09B4CDAB for pgsql-sql@postgresql.org; Sat, 5 Apr 2008 19:46:55 +0200 X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: AigMALZX90esHwAm/2dsb2JhbAAIjTmcfQ Received: from unknown (HELO smtp-out2.libero.it) ([172.31.0.38]) by outrelay10.libero.it with ESMTP; 05 Apr 2008 19:46:55 +0200 Received: from libero.it (192.168.17.7) by smtp-out2.libero.it (7.3.120) id 4611FD4B0540C11F for pgsql-sql@postgresql.org; Sat, 5 Apr 2008 19:46:55 +0200 Date: Sat, 5 Apr 2008 19:46:55 +0200 Message-Id: Subject: Problem with now() in function pgsql MIME-Version: 1.0 X-Sensitivity: 3 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable From: "luke\.78\@libero\.it" To: "pgsql-sql" X-XaM3-API-Version: 4.3 (R1) (B3pl25) X-SenderIP: 151.60.44.81 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200804/30 X-Sequence-Number: 30569 Hi, I have a problem in a function pgsql with Reading TIMESTAMP calling the f= unction now() the problem is this: At the begin of function I read timestamp... select now() into TS_BEGIN; the function execute some statement... Many seconds after I reread the timestamp select now() into TS_END; and TS_BEGIN is identical TS_END!!! Can anyone help me? Thanks in advance. Luke.