Re: [SQL] calculated expressions and index use

constant expression should be recognized, pushed me much further. Thanks again Have a nice day Pavel Tom Lane wrote: Pavel Hlavnicka <[EMAIL PROTECTED]> writes: I use 7.2.1. :( 7.2 certainly will fold "'now'::timestamp - '1 hour'::interval" to a tim

Re: [SQL] 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 <[EMAIL PROTECTED]> writes: select * from foo where created_at >= 'now'::timestamp - '1 hour

[SQL] calculated expressions and index use

d 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