Skip site navigation (1) Skip section navigation (2)

Re: Clarify use of NOW() in pl/pgsql docs

From: Michael Glaesemann <grzm(at)myrealbox(dot)com>
To: Neil Conway <neilc(at)samurai(dot)com>
Cc: David Fetter <david(at)fetter(dot)org>,PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Clarify use of NOW() in pl/pgsql docs
Date: 2005-02-10 07:32:05
Message-ID: 4759ec048fa2cb2accaaf0621ac6765e@myrealbox.com (view raw or flat)
Thread:
Lists: pgsql-patches
On Feb 10, 2005, at 14:00, Neil Conway wrote:

> On Thu, 2005-01-27 at 02:28 -0800, David Fetter wrote:
>> This one from Ben Calvert.  It uses the (imho clearer) NOW() rather
>> than 'NOW' in a PL/PgSQL function example.
>
> Applied, thanks.

I realize it's a bit late, but it might not be a bad idea to use 
CURRENT_TIMESTAMP rather than NOW(), as it's per SQL spec.

Michael Glaesemann
grzm myrealbox com


In response to

Responses

pgsql-patches by date

Next:From: Martin PittDate: 2005-02-10 09:41:32
Subject: Re: libpq API incompatibility between 7.4 and 8.0
Previous:From: Neil ConwayDate: 2005-02-10 06:57:48
Subject: Re: WIP: pl/pgsql cleanup

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group