On Fri, 4 Feb 2022 at 13:21, Les <nagylzs@gmail.com> wrote:
>
>> What if you try applying the C collation to the values from the table:
>>
>> where fi.is_active and fi.relpath collate "C" ^@ 'A'
>
>
> Slow
What about this:
fi.relpath between ('A' collate "C") and ('A'||chr(255) collate "C")