Home > mailing lists

Re: locales and encodings Oh MY! - Mailing list pgsql-admin

From	Kevin Grittner
Subject	Re: locales and encodings Oh MY!
Date	November 12, 2010 16:58:32
Msg-id	4CDD2BD902000025000376CD@gw.wicourts.gov Whole thread Raw
In response to	locales and encodings Oh MY! ("mark" <dvlhntr@gmail.com>)
List	pgsql-admin

Tree view

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-admin by date:

From: Guillaume Lelarge
Date: 12 November 2010, 16:50:01
Subject: Re: Trigger: Column Update

From: Ricardo Bayley
Date: 12 November 2010, 17:26:30
Subject: Re: Trigger: Column Update

Re: locales and encodings Oh MY! - Mailing list pgsql-admin

Previous

Next