Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Has the single-byte LIKE penalty been eliminated, so we don't need to > > consider using C as the default locale for initdb, right? > > I'm still of the opinion that we should make C the default locale. > But I'm not sure where the consensus is, so I've not made the change. > > > If fixed, how was it done? > > Peter has provided a hack whereby one can create a LIKE-supporting index > in a non-C locale. But a *default* index in a non-C locale is still not > going to support LIKE ... and the hacked index will not support ordinary > comparison or ordering operators. So I think there's still a lot left > to be desired here.
So, my understanding is that you would create something such as: CREATE INDEX iix ON tab (LIKE col) and that does LIKE lookups and knows how to do col LIKE 'abc%', but it can't be used for >= or ORDER BY, but it can be used for equality tests? -- 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 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]