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/