"Johannes" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
