Re: calculated expressions and index use

I use 7.2.1. :(

Do you thing my considerations on constant vs. expression are correct? I
tried different syntax, no success.

Thanks

Pavel

Tom Lane wrote:
> Pavel Hlavnicka <pavel(at)gingerall(dot)cz> writes:
>
>>select * from foo
>>where created_at >= 'now'::timestamp - '1 hour'::interval;
>
>
>>My table is indexed on created_at field. The query above doesn't use it,
>
>
> What's your PG version? In 7.2 and later that expression will be folded
> to a constant.
>
> regards, tom lane

--
Pavel Hlavnicka
Ginger Alliance
www.gingerall.com