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