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@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073