Re: Need timestamp function that will change within a transaction

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()) * 100000)::bigint;
>
> The problem is that NOW() does not change within a transaction and
> so I keep getting the same value.  Is there a function that will
> return a timestamp that is NOT consistent within a transaction?

Take a look at statement_timestamp() or clock_timestamp()

Cheers,
   Steve