Re: Query in function not using index...

Listmail <lists@peufeu.com> 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