[DOCS] pattern matching indexing

2012-12-24 Thread Peter Eisentraut 
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?

Also, there is no link from
http://www.postgresql.org/docs/devel/static/functions-matching.html to
either option.



-- 
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs

Re: [DOCS] pattern matching indexing

2012-12-24 Thread Tom Lane 
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
> 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