Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Sat, 24 Feb 2007 22:01:17 -0700
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
- References:
- some tables unicode, some ascii?
- From: Gene
- some tables unicode, some ascii?
- Prev by Date: Re: Inserting a new column in between.
- Next by Date: Re: Why can't I put a BEFORE EACH ROW trigger on a view?
- Previous by thread: some tables unicode, some ascii?
- Next by thread: Inserting a new column in between.
- Indexes: