Bruce Momjian wrote: > However, I am wondering if we should create a character lookup during > initdb that has the characters ordered so we can do:
That won't work. Real-life collations are too complicated. > Also, we mention you should use the "C" locale to use normal indexes > for LIKE but isn't it more correct to say the encoding has to be > SQL_ASCII? No, the locale decides the ordering. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
