Re: some tables unicode, some ascii?

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: gene(at)sotech(dot)us
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: some tables unicode, some ascii?
Date: 2007-02-25 05:01:17
Message-ID: 20070225050117.GA62625@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jaime Casanova 2007-02-25 05:24:40 Re: Why can't I put a BEFORE EACH ROW trigger on a view?
Previous Message Joshua D. Drake 2007-02-25 04:59:50 Re: Inserting a new column in between.