Horton

Re: [SQL] CURRENT_TIMESTAMP

Bruce Momjian <pgman@candle.pha.pa.us>

View thread View on postgr.es
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Roland Roberts <roland@astrofoto.org>
Cc: pgsql-sql@postgresql.org, pgsql-general@postgresql.org
Date: 2002-09-24T21:56:51Z
Lists: pgsql-hackers, pgsql-general, pgsql-sql 
Roland Roberts wrote:
> >>>>> "Ross" == Ross J Reedstrom <reedstrm@rice.edu> writes:
> 
>     Ross> Oh, interesting datapoint. Let me get this clear - on
>     Ross> oracle, the equivalent of:
> 
> Well, I've never gone off to lunch in the middle, but in Oracle 7, I
> had transactions which definitely took as much as a few minutes to
> complete where the timestamp on every row committed was the same.

Can you run a test:

	BEGIN;
	SELECT CURRENT_TIMESTAMP;
	wait 5 seconds
	SELECT CURRENT_TIMESTAMP;

Are the two times the same?

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073