| From: | Roland Roberts <roland(at)astrofoto(dot)org> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: [SQL] CURRENT_TIMESTAMP |
| Date: | 2002-09-24 14:55:41 |
| Message-ID: | m2fzvzv3ma.fsf@kuiper.rlent.pnet |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers pgsql-sql |
>>>>> "Martijn" == Martijn van Oosterhout <kleptog(at)svana(dot)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(at)rlenter(dot)com 76-15 113th Street, Apt 3B
roland(at)astrofoto(dot)org Forest Hills, NY 11375
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2002-09-24 15:04:38 | Re: grant/revoke for alter/drop? |
| Previous Message | Yury Bokhoncovich | 2002-09-24 14:50:30 | Re: Different Port for PostgreSQL? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2002-09-24 15:05:59 | Re: [GENERAL] CURRENT_TIMESTAMP |
| Previous Message | Tom Lane | 2002-09-24 13:53:10 | Re: ECPG |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2002-09-24 15:05:59 | Re: [GENERAL] CURRENT_TIMESTAMP |
| Previous Message | Matteo Beccati | 2002-09-24 14:20:38 | Re: select case problem |