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

Поиск
Список
Период
Сортировка
От Mike Nolan
Тема Re: 'like' refuses to use an index???
Дата
Msg-id 200312302222.hBUMMO5C003302@gw.tssi.com
обсуждение исходный текст
Ответ на Re: 'like' refuses to use an index???  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: 'like' refuses to use an index???
Список pgsql-general
> Mike Nolan <nolan@gw.tssi.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


В списке pgsql-general по дате отправления:

Предыдущее
От: "Keith C. Perry"
Дата:
Сообщение: Re: 'like' refuses to use an index???
Следующее
От: Tom Lane
Дата:
Сообщение: Re: 'like' refuses to use an index???