Re: Optimizing >= and <= for numbers and dates

On Wed, 2003-10-01 at 13:30, Dimitri Nagiev wrote:
> Hi all,
>
> I haven't found any official documentation about the postgres sql optimizer
> on the web, so please forgive me if there is such a document and point me to
> the right direction.
>
> I've got the following problem: I cannot make the postgres SQL Optimizer use
> an index on a date field to filter out a date range, e.g.
>
> select * from mytable where mydate >= '2003-10-01';
>
> Seq Scan on mytable (cost=0.00..2138.11 rows=12203 width=543)
> Filter: (mydate >= '2003-09-01'::date)

EXPLAIN ANALYZE output please.