Re: values from now() in the same transaction - Mailing list pgsql-general

From Ron Johnson
Subject Re: values from now() in the same transaction
Date
Msg-id 45D64F75.3060106@cox.net
Whole thread Raw
In response to Re: values from now() in the same transaction  (Chris Browne <cbbrowne@acm.org>)
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 02/16/07 17:25, Chris Browne wrote:
> zelvlad@yahoo.com (Vladimir Zelinski) writes:
>> I tried function now(),current_timestamp() but all of
>> them behave similar.
>>
>> I don't believe that it's bug, probably it's a feature
>> of the postgreSql database.
>
> Indeed, that is intentional.  CURRENT_TIMESTAMP and NOW() return the

Ooooh, is that Standard Behavior?

Is there a standard definition for CURRENT_TIMESTAMP?
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFF1k91S9HxQb37XmcRAqFsAKCMI+xzFxig2XMDPcsWcRMfToOJ/QCffWwO
iLBhZIc3jGp2VWwVSxW7hRQ=
=RTIl
-----END PGP SIGNATURE-----

pgsql-general by date:

Previous
From: Jerry LeVan
Date:
Subject: Synchronize tables question....
Next
From: Bruce Momjian
Date:
Subject: Re: user input during runtime