Re: Query in function not using index... - Mailing list pgsql-general

From Tom Lane
Subject Re: Query in function not using index...
Date
Msg-id 13866.1177781064@sss.pgh.pa.us
Whole thread Raw
In response to Re: Query in function not using index...  (Listmail <lists@peufeu.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "Marcelo de Moraes Serpa"
Date:
Subject: "Protocol error. Session setup failed" (PostgreSQL 8.3devel/postgresql-8.3dev-600.jdbc3)
Next
From: Andrew - Supernews
Date:
Subject: Re: Processing a work queue