Received: from maia.hub.org (maia-4.hub.org [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id B3A286355FD for ; Wed, 19 May 2010 05:26:26 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 44355-01 for ; Wed, 19 May 2010 08:26:19 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moon.antora.ru (moon.antora.ru [89.111.189.180]) by mail.postgresql.org (Postfix) with ESMTP id 53B9B63536C for ; Wed, 19 May 2010 05:26:19 -0300 (ADT) Envelope-to: pgsql-sql@postgresql.org Received: from moon.inner.space ([10.1.1.5] helo=moon.antora.ru) by moon.antora.ru with esmtp (Exim 4.67) (envelope-from ) id 1OEebV-0005Kp-9E for pgsql-sql@postgresql.org; Wed, 19 May 2010 12:26:14 +0400 Received: from [192.168.1.6] [178.34.4.77] by moon.antora.ru (Axigen) with (DHE-RSA-AES256-SHA encrypted) ESMTPSA id 1D6CA8; Wed, 19 May 2010 12:26:10 +0400 Message-ID: <4BF3A09F.9090906@bankir.ru> Date: Wed, 19 May 2010 12:26:07 +0400 From: silly sad User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.1.5) Gecko/20100111 Thunderbird/3.0 MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re: How to get CURRENT_DATE in a pl/pgSQL function References: <20100518190832.GQ3892@aart.is.rice.edu> <20100518192721.GS3892@aart.is.rice.edu> In-Reply-To: <20100518192721.GS3892@aart.is.rice.edu> 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=0.8 tagged_above=-5 required=5 tests=BAYES_50=0.8 X-Spam-Level: X-Archive-Number: 201005/86 X-Sequence-Number: 34134 On 05/18/10 23:27, Kenneth Marshall wrote: > It works using 'now' and I assume that since curtime is now() is NOT the CURRENT timestamp in fact, it is about the timestamp of the current transaction has been started. it is the really USEFUL value, still u have to remember this meaning.