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 [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? http://www.postgresql.org/docs/faqs/FAQ.html