Re: [GENERAL] CURRENT_TIMESTAMP - Mailing list pgsql-sql

From Roland Roberts
Subject Re: [GENERAL] CURRENT_TIMESTAMP
Date
Msg-id m2fzvzv3ma.fsf@kuiper.rlent.pnet
Whole thread Raw
In response to Re: [GENERAL] Monitoring a Query  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [GENERAL] CURRENT_TIMESTAMP
List 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

pgsql-sql by date:

Previous
From: "Matteo Beccati"
Date:
Subject: Re: select case problem
Next
From: "Josh Berkus"
Date:
Subject: Re: [GENERAL] CURRENT_TIMESTAMP