On Sat, Feb 24, 2007 at 11:35:10PM -0500, Gene wrote:
> Is there a way to get the benefit of using ascii and the "C" locale
> for index usage on certain tables and unicode encoding on others
> (where peformance is not an issue)? In particular the planner will
> not use index with Unicode on "like '123%' " queries.
See "Operator Classes" in the "Indexes" chapter of the documentation.
http://www.postgresql.org/docs/8.2/interactive/indexes-opclass.html
--
Michael Fuhr