Re: Query in function not using index...

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: Query in function not using index...
Дата
Msg-id
13866.1177781064@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
Re: Query in function not using index... John Cole <john.cole@uai.com>
Re: Query in function not using index... Listmail <lists@peufeu.com>
Re: Query in function not using index... Tom Lane <tgl@sss.pgh.pa.us>
Listmail  writes:
>> We were looking at the explain results and noticed that it was  
>> converting
>> the 'wynn%' into fname >= 'wynn' and fname < 'wyno'

> 	Does this also work if the last character is a unicode character ?

In C locale it does, though you have to be careful to avoid generating
an invalid encoding.

			regards, tom lane
В списке pgsql-general по дате отправления
От: Marcelo de Moraes Serpa
Дата:
От: Andrew - Supernews
Дата:
Сообщение: Re: Processing a work queue
FAQ