Postgres Pro
Downloads
Home   >   mailing lists

Re: Index scan vs. Seq scan on timestamps - Mailing list pgsql-general

From Andrew - Supernews
Subject Re: Index scan vs. Seq scan on timestamps
Date
Msg-id slrncra7tv.sjo.andrew+nonews@trinity.supernews.net
Whole thread Raw
In response to Index scan vs. Seq scan on timestamps  (Per Jensen <per@net-es.dk>)
Responses Re: Index scan vs. Seq scan on timestamps  (pj@net-es.dk (Per Jensen))
Re: Index scan vs. Seq scan on timestamps  (pj@net-es.dk (Per Jensen))
List pgsql-general
Tree view 
On 2004-12-07, Stephen Frost <sfrost@snowman.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?

--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services

pgsql-general by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Index scan vs. Seq scan on timestamps
Next
From: cheng shan
Date:
Subject: Triggers don't activate when dropping table