Re: time stops within transaction

----- Original Message -----
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Alex Pilosov <alex@pilosoft.com>
Cc: <pgsql-hackers@postgresql.org>
Sent: Wednesday, 18 October 2000 16:21
Subject: Re: [HACKERS] time stops within transaction


> Wow, that is strange.
>
>
> > I just ran into a strangest thing: within transaction, select now() will
> > always return time when transaction started. Same happens with select
> > 'now'::timestamp.
> >


Actually, thats useful since you can put now()  into multiple fields in one
transaction.

The alternative is that CURRENT_TIMESTAMP  (??? is that the one) which isn't a
function
and stuffs up when trying to use it as a field default or as part of an
expression in a view.

(Comment true for 6.5.3 at least)
Documentation on time constants and how to misuse them is weak...

Regards