Re: calculated expressions and index use - Mailing list pgsql-sql

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@gingerall.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