| From: | Mike Nolan <nolan(at)gw(dot)tssi(dot)com> |
|---|---|
| To: | tgl(at)sss(dot)pgh(dot)pa(dot)us (Tom Lane) |
| 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-30 22:22:23 |
| Message-ID: | 200312302222.hBUMMO5C003302@gw.tssi.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> 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.
Hmm. is the 'C' locale going to be faster than SQL_ASCII?
Second dumb question: What is there about SQL_ASCII that a 'like'
cannot use indexes?
--
Mike Nolan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Keith C. Perry | 2003-12-30 22:22:34 | Re: 'like' refuses to use an index??? |
| Previous Message | Keith C. Perry | 2003-12-30 22:17:12 | Re: 'like' refuses to use an index??? |