X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id BF925D1B51A for ; Mon, 29 Sep 2003 13:14:34 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 79056-05 for ; Mon, 29 Sep 2003 10:14:07 -0300 (ADT) Received: from serwer.skawsoft.com.pl (skawina.eu.org [80.48.213.66]) by svr1.postgresql.org (Postfix) with ESMTP id 758E0D1B51D for ; Mon, 29 Sep 2003 10:14:03 -0300 (ADT) Received: from klaster.net (core-1.citynet.pl [80.48.135.69]) by serwer.skawsoft.com.pl (Postfix) with ESMTP id D097E2B3E7; Mon, 29 Sep 2003 15:13:58 +0200 (CEST) Message-ID: <3F783022.8030207@klaster.net> Date: Mon, 29 Sep 2003 15:14:10 +0200 From: Tomasz Myrta User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; pl-PL; rv:1.5) Gecko/20030916 X-Accept-Language: pl, en-us, en MIME-Version: 1.0 To: Kerv Cc: pgsql-sql@postgresql.org Subject: Re: now() in loop statement References: In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/380 X-Sequence-Number: 15358 > Hello, > > What is wrong with this function because the mytime variable contain the > same value in each iteration: Just like it should be. now() gives you always the same value inside single transaction. If you need time for performance tests - use "timeofday". Regards, Tomasz Myrta