[HACKERS] Locale vs LIKE

2008-02-12 Thread Stephen Denne
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

Re: [HACKERS] Locale vs LIKE

2008-02-12 Thread Gregory Stark
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!