Paul Vinkenoog schrieb am 22.03.2011 um 00:06 (+0100):

> Hi Helen,
>
> > >I (mis)understood your statement as saying that CURRENT_TIMESTAMP
> > >remains constant during a transaction (which of course it doesn't)
> >
> > Yes, it does.
>
> No, it doesn't, but it *does* remain constant during execution of a
> PSQL module, whereas 'NOW' keeps progressing.

Okay, I didn't know that. Thanks!

> In DSQL, CURRENT_TIMESTAMP also progresses during a transaction.

That's what I was referring to. In DSQL, using isql.exe from 2.5:

select current_timestamp, current_transaction from rdb$database;

2011-03-22 00:17:27.0000 1884
2011-03-22 00:17:27.9060 1884
2011-03-22 00:17:28.9530 1884

--
Michael Ludwig