Re: some tables unicode, some ascii?

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