Re: pattern matching indexing

Peter Eisentraut <peter_e@gmx.net> 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
> between the lines).  Is that intentional?

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
obscure.

            regards, tom lane