Re: [SQL] [GENERAL] CURRENT_TIMESTAMP

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [SQL] [GENERAL] CURRENT_TIMESTAMP
Date: 2002-10-03 23:58:39
Message-ID: 20021003195839.A16643@mail.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-sql

On Thu, Oct 03, 2002 at 07:09:33PM -0400, Tom Lane wrote:

> statement-arrival time. (I like the idea of a parameterized version of
> now() to provide a consistent interface to all three functionalities.)

I like this, too. I think it'd be probably useful. But. . .

> pride of place to statement-arrival time. In the end, I think that
> transaction-start time is the most commonly useful and safest variant,

. . .I also think this is true. If I'm doing a bunch of database
operations in one transaction, there is a remarkably good argument
that they happened "at the same time". After all, the marked passage
of time is probably just an unfortunate side effect of the inability
of my database can't process things instantaneously.

A

--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-10-03 23:59:56 Re: [GENERAL] Performance while loading data and indexing
Previous Message Marc G. Fournier 2002-10-03 23:50:23 v7.2.3 Released to fix Potentially Critical Bug

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2002-10-03 23:59:56 Re: [GENERAL] Performance while loading data and indexing
Previous Message Tom Lane 2002-10-03 23:53:39 Re: [GENERAL] Small patch for PL/Perl Misbehavior with Runtime Error Reporting

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 2002-10-04 00:41:58 Re: [SQL] [GENERAL] CURRENT_TIMESTAMP
Previous Message Tom Lane 2002-10-03 23:09:33 Re: [SQL] [GENERAL] CURRENT_TIMESTAMP