Re: default locale considered harmful? (was Re: [GENERAL]

Peter Eisentraut wrote:
> Bruce Momjian writes:
>
> > Our default indexes will be able to do =, >, <, ORDER BY, and the
> > special index will be able to do LIKE, ORDER BY, and maybe equals. Do I
> > have that correct?
>
> The default operator class supports comparisons (=, >, <, etc.) and ORDER
> BY based on those operators. The other operator class supports pattern
> matching operations (LIKE, SIMILAR, POSIX regexps).
>
> > Looking at CVS, I see the warning about non-C locales has been removed.
> > Should we instead mention the new LIKE index method?
>
> I don't see a need. The old warning was mainly because once you
> initdb'ed, you were basically stuck with your choice. Now we have plenty
> of options to query and adjust things later.

How are people going to know to use these special LIKE indexes?

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073