Thomas Lockhart writes: > > In a transaction until you commit your transaction through a jdbc > > connection, each time you use the Current_timestamp (or 'now'), the > > timestamps is always the same, and when your transaction is very long you > > have undesirable effect. > > This is not a bug, but the behavior required by SQL9x afaicr.
AFAIK, this is PostgreSQL bugward compatibility. SQL says that current_timestamp returns the "current timestamp", which you can interpret any way you want to. -- Peter Eisentraut [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
