Re: BUG #2050: Bad plan by using of LIKE - Mailing list pgsql-bugs

"Johannes" <postgres@arltus.de> writes:
> EXPLAIN SELECT title FROM content WHERE title LIKE 'teane%';
> Seq Scan on content  (cost=0.00..75647.59 rows=1 width=68)
>    Filter: (title ~~ 'teane%'::text)

Apparently you're using a non-C locale.  LIKE can only use an index if
you're in the C locale or you make the index with a special index
operator class.  See
http://www.postgresql.org/docs/8.0/static/indexes-opclass.html

            regards, tom lane