Peter Eisentraut <peter_e(at)gmx(dot)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