Re: [GENERAL] Need timestamp function that will change within a transaction

2008-05-14 Thread Dimitri Fontaine
-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-CU

Re: [GENERAL] Need timestamp function that will change within a transaction

2008-05-14 Thread Steve Atkins
On May 14, 2008, at 12:56 PM, D. Dante Lorenso wrote: I'd like to find a timestamp function that WILL change within a transaction. This function will return to me a 15 digit BIGINT number in base10: SELECT FLOOR(EXTRACT(EPOCH FROM NOW()) * 10)::bigint; The problem is that NOW() does n