Peter Eisentraut <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
