Listmail <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
