Re: Index scan vs. Seq scan on timestamps

From: pj(at)net-es(dot)dk (Per Jensen)
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Index scan vs. Seq scan on timestamps
Date: 2004-12-07 08:25:20
Message-ID: 20041207082520.GA16887@balrog.net-es.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Den Tue, Dec 07, 2004 at 03:13:04AM -0000 eller der omkring skrev Andrew - Supernews:
> On 2004-12-07, Stephen Frost <sfrost(at)snowman(dot)net> wrote:
> > Is there a way to say "just take the value of this function at the start
> > of the transaction and then have it be constant" in a query?
>
> Why not use CURRENT_TIMESTAMP, etc., which do exactly that?
>

Because when using transactions, CURRENT_TIMESTAMP does not advance, but is fixed
to time of session start

/Per

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2004-12-07 08:31:13 Re: Drop table
Previous Message Nageshwar Rao 2004-12-07 07:50:07 Drop table