On 04.07.2019 19:50, Daniel Verite wrote:
> Yes. It is because of the index that the code checks if the ILIKE
> can be evaluated with an index lookup. Otherwise it doesn't.
>
> If you feel like recompiling with a temporary fix against v11.4 to do
> your own tests, please try the attached patch.
Also this patch works. I thinks we need to use some ICU function to
check whether a char is a letter.
--
Arthur Zakirov
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company