Re: String matching

PFC wrote:
>
>     normally you shouldn't have to do anything, it should just work :
>
>> select field from table where field like 'abc%'

>     If it does not use the index, I saw on the mailing list that the
> locale  could be an issue.

Oh yes, I forgot about that :( I do have LC_COLLATE (on latin2)...

It's a shame PostgreSQL doesn't allow collation rules on specific fields
- this field I'm using here will always be 7bit ASCII :(