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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
