> > http://www.postgresql.org/docs/8.1/static/indexes-types.html > > says: > > The optimizer can also use a B-tree index for queries involving the > > pattern matching operators LIKE, ILIKE, ~, and ~*, if the > pattern is a > > constant and is anchored to the beginning of the string - > for example, > > col LIKE 'foo%' or col ~ '^foo', but not col LIKE '%bar'. > > > But really, does it use indexes for ILIKE? > > That's pretty poorly phrased. For ILIKE it'll only work if > there's a prefix of the pattern that's not letters (and hence > is unaffected by the case-folding issue).
Ahh. That explains it. Perfectly logical. And yes, that's pretty poorly phrased - at least I didn't understand it :-) //Magnus ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
