On Thu, Sep 11, 2008 at 10:08 AM, Marcus Engene <[EMAIL PROTECTED]> wrote: > select > objectid > from > apa > where > created_at > now() - interval '1 day' > order by > objectid desc; > > In this select, it would have been nice to dodge the full table scan without > adding an index to created_at. Is this possible somehow?
Not really. It's a choice of one or the other. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
