Peter Eisentraut <pete...@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 -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
