Re: Index scan vs. Seq scan on timestamps

From: Andrew - Supernews <andrew+nonews(at)supernews(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Index scan vs. Seq scan on timestamps
Date: 2004-12-07 03:13:04
Message-ID: slrncra7tv.sjo.andrew+nonews@trinity.supernews.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message cheng shan 2004-12-07 03:44:58 Triggers don't activate when dropping table
Previous Message Stephen Frost 2004-12-07 02:49:25 Re: Index scan vs. Seq scan on timestamps