[SQL] calculated expressions and index use

[Pavel Hlavnicka]

Hi all,

I use simple sql statement like this

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, but if I use

select * from foo where created_at >= 'now'

the index is used.

It looks like if the engine finds some expression to be evaluated it gets rid of any index use (due the possible dependency?).

Is it possible to do something to 'precompute' some value in the query condition, so planner understand is as a constant value?

(... and I've got some reason NOT to use a parameter in my Perl DBI code...)

Maybe my conclusions are wrong, of course.

Thank you very much in advance

Pavel

--
Pavel Hlavnicka
Ginger Alliance
www.gingerall.com


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