Re: Index on timestamp field, and now() - Mailing list pgsql-general

From Tom Lane
Subject Re: Index on timestamp field, and now()
Date
Msg-id 21751.1013529121@sss.pgh.pa.us
Whole thread Raw
In response to Re: Index on timestamp field, and now()  (Denis Perchine <dyp@perchine.com>)
Responses Re: Index on timestamp field, and now()  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
Denis Perchine <dyp@perchine.com> writes:
> Oups. Sorry my mistake. But 7.2's limited understanding is enough to do
> constant propagation as far as I can see. :-)))

Correct, it's the now() function that's not cachable --- but you can get
around that with the "timestamp 'now'" kluge.

            regards, tom lane

pgsql-general by date:

Previous
From: Denis Perchine
Date:
Subject: Re: Index on timestamp field, and now()
Next
From: Tom Lane
Date:
Subject: Re: index use again and again