Re: [DOCS] pattern matching indexing

2012-12-27 Thread Tom Lane
Peter Eisentraut writes: > On Mon, 2012-12-24 at 10:12 -0500, Tom Lane wrote: >> 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

Re: [DOCS] pattern matching indexing

2012-12-27 Thread Peter Eisentraut
On Mon, 2012-12-24 at 10:12 -0500, Tom Lane wrote: > 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

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

[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.postgres