Re: [SQL] calculated expressions and index use

[Pavel Hlavnicka]

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 <[EMAIL PROTECTED]> 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


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster