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                        |
  [EMAIL PROTECTED]               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

Reply via email to