Re: [GENERAL] CURRENT_TIMESTAMP

Поиск
Список
Период
Сортировка
От Roland Roberts
Тема Re: [GENERAL] CURRENT_TIMESTAMP
Дата
Msg-id m2fzvzv3ma.fsf@kuiper.rlent.pnet
обсуждение исходный текст
Ответ на Re: [GENERAL] Monitoring a Query  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [GENERAL] CURRENT_TIMESTAMP  ("Ross J. Reedstrom" <reedstrm@rice.edu>)
Список 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 по дате отправления:

Предыдущее
От: "Matteo Beccati"
Дата:
Сообщение: Re: select case problem
Следующее
От: "Josh Berkus"
Дата:
Сообщение: Re: [GENERAL] CURRENT_TIMESTAMP