Re: Need timestamp function that will change within a transaction - Mailing list pgsql-general

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

Le 14 mai 08 à 21:56, D. Dante Lorenso a écrit :

> I'd like to find a timestamp function that WILL change within a
> transaction.

See the fine manual:
   http://www.postgresql.org/docs/current/static/functions-datetime.html#FUNCTIONS-DATETIME-CURRENT

It saith that timeofday() and clock_timestamp() are what you're after.
Most likely it's clock_timestamp().

Regards,
- --
dim
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (Darwin)

iEYEARECAAYFAkgrRr8ACgkQlBXRlnbh1bmrjgCgqjOiIkQ+EvZi262FYYzRjol1
V9QAoIoj9wYb01K8e939F/LkZ2fDjVpg
=rI75
-----END PGP SIGNATURE-----