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

Re: 'like' refuses to use an index???

From: Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Mike Nolan <nolan(at)gw(dot)tssi(dot)com>
Cc: dmitry(at)openratings(dot)com (Dima Tkach),pgsql-general(at)postgresql(dot)org (PostgreSQL General)
Subject: Re: 'like' refuses to use an index???
Date: 2003-12-31 15:10:09
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
El Mar 30 Dic 2003 19:06, Tom Lane escribió:
> Mike Nolan <nolan(at)gw(dot)tssi(dot)com> writes:
> > However, I think RH always sets the LANG environmental variable, so 
> > that's going to be picked up by initdb, which means that the C locale 
> > will NOT be used unless specifically asked for.  Other OS packages may
> > also force the choice of a default LANG value. 
> Yeah.  There have been some discussions on pgsql-hackers about
> defaulting to C locale instead of honoring LANG, but we haven't done
> anything.

Which would the loses be in using C locale, for example, for Spanish speeking 
people, where we have acute letters and ñ (charset iso-8859-1)? Would it be 
only ordering?

select 'mmarques' || '@' || '' AS email;
Martín Marqués                  |        mmarques(at)unl(dot)edu(dot)ar
Programador, Administrador, DBA |       Centro de Telemática
                       Universidad Nacional
                            del Litoral

In response to

pgsql-general by date

Next:From: Tom LaneDate: 2003-12-31 16:16:48
Subject: Re: Is my MySQL Gaining ?
Previous:From: George EssigDate: 2003-12-31 14:52:48
Subject: Re: website doc search is extremely SLOW

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