Re: [SQL] CURRENT_TIMESTAMP
Roland Roberts <roland@astrofoto.org>
From: Roland Roberts <roland@astrofoto.org>
To: pgsql-sql@postgresql.org, pgsql-general@postgresql.org
Date: 2002-09-24T14:55:41Z
Lists: pgsql-hackers, pgsql-general, pgsql-sql
>>>>> "Martijn" == Martijn van Oosterhout <kleptog@svana.org> writes:
Martijn> Well, what I would suggest is that when you wrap several
Martijn> statements into a single transaction with begin/commit,
Martijn> the whole lot could be considered a single statement
Martijn> (since they form an atomic transaction so in a sense they
Martijn> are all executed simultaneously). And hence Postgresql is
Martijn> perfectly compliant.
FWIW, and not that I am an Oracle fan :-), Oracle seems to interpret
this the same way when using a "select sysdate from dual" inside a
transaction.
roland
--
PGP Key ID: 66 BC 3B CD
Roland B. Roberts, PhD RL Enterprises
roland@rlenter.com 76-15 113th Street, Apt 3B
roland@astrofoto.org Forest Hills, NY 11375