Given the improvements in 8.3 listed in the release notes:
- Improve efficiency of LIKE/ILIKE, especially for multi-byte character sets
like UTF-8 (Andrew, Itagaki Takahiro)
Does this still hold:
http://www.postgresql.org/docs/8.3/interactive/locale.html
The drawback of using locales other than
Stephen Denne [EMAIL PROTECTED] writes:
i.e. Do I still have to either initdb --locale=C or explicitly use
text_pattern_ops?
yes, if you want an index to be used
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's PostGIS support!