Skip site navigation (1) Skip section navigation (2)

Re: locales and encodings Oh MY!

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <gabriele(dot)bartolini(at)2ndquadrant(dot)it>,<dvlhntr(at)gmail(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>,<pgsql-hackers(at)postgresql(dot)org>
Subject: Re: locales and encodings Oh MY!
Date: 2010-11-12 17:58:17
Message-ID: 4CDD2BD902000025000376CD@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-hackers
mark  wrote:
 
> A "fix" being so that "col LIKE 'foo%' " could use btree indexes in
> locales like en_US.UTF8 (and probably some others).
 
How about specifying an opclass?:
 
http://www.postgresql.org/docs/current/interactive/indexes-opclass.html
 
-Kevin

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2010-11-12 18:04:03
Subject: Re: ask for review of MERGE
Previous:From: Bruce MomjianDate: 2010-11-12 17:24:13
Subject: Re: knngist - 0.8

pgsql-admin by date

Next:From: Ricardo BayleyDate: 2010-11-12 18:26:16
Subject: Re: Trigger: Column Update
Previous:From: Guillaume LelargeDate: 2010-11-12 17:49:52
Subject: Re: Trigger: Column Update

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group