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