On 9/5/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> Martin Langhoff escribió:
>
> > As I have a Pg install where the locale is already en_US.UTF-8, and
> > the database already exists, is there a DB-scoped way of controlling
> > the locale?
>
> Not really.
Ah well. But I do have to wonder why..
Martin Langhoff escribió:
> On 9/5/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> > Martin Langhoff escribió:
> >
> > > As I have a Pg install where the locale is already en_US.UTF-8, and
> > > the database already exists, is there a DB-scoped way of controlling
> > > the locale?
> >
> > Not reall
2007/9/5, Martin Langhoff <[EMAIL PROTECTED]>:
> Hi!
>
> I am having a bit of trouble with indexes, locales and LIKE queries.
>
> Background
> --
>
> Using Pg8.1/8.2 on a utf-8 database, my left-anchored LIKE clauses were
> forcing a full table scan instead of using the index. After a bit o
"Alvaro Herrera" <[EMAIL PROTECTED]> writes:
> Martin Langhoff escribió:
>
>> the whole thing of figuring out what the locale is and whether to add
>> magical additional indexes just for Pg makes me look like a loony.
>
> You are right and Eloy is wrong on that discussion. There is not
> anything
Martin Langhoff escribió:
> As I have a Pg install where the locale is already en_US.UTF-8, and
> the database already exists, is there a DB-scoped way of controlling
> the locale?
Not really.
> Is there a better way? In this specific install I can create the
> additional index. However, this ne
