Re: [DOCS] pattern matching indexing

2012-12-27 Thread Tom Lane
Peter Eisentraut writes: > On Mon, 2012-12-24 at 10:12 -0500, Tom Lane wrote: >> It is stated at >> http://www.postgresql.org/docs/devel/static/indexes-opclass.html >> that you don't need the special pattern opclasses in C locale. >> Feel free to rephrase or document elsewhere if you find that too

Re: [DOCS] pattern matching indexing

2012-12-27 Thread Peter Eisentraut
On Mon, 2012-12-24 at 10:12 -0500, Tom Lane wrote: > Peter Eisentraut writes: > > To index pattern matching, you can use the _pattern_ops operator > > classes, or you can set the column collation in the index to "C". The > > latter option doesn't appear to be documented (unless you read very deep