POSTGRE : using ILIKE instead of LIKE

Hello,

For POSTGRE DB, it would be better to use "ILIKE" command for any request auto generated with multi-column filters, than LIKE (which is a SQL command).

Thanks

Could you please explain why ILIKE is better than LIKE? I'd say both of them are SQL commands.

Because of this :

We won't have this error if HeidiSQL is using ILIKE command instead of LIKE

Ok, then what's the general difference between both?

'name' LIKE "%paris%" doesn't work whereas 'name' ILIKE "%paris%" is working

ILIKE accepts "%"

According to this tutorial and the official docs, ILIKE is just the case insensitive version of LIKE. But if you say ILIKE in contrast to LIKE also works for double precision columns, the docs must be incomplete here.

With ILIKE, I am now getting

Operator existiert nicht: timestamp with time zone ~~* unknown

Same with LIKE, so I will have to cast TIMESTAMP columns as text.

I modified internal queries for that multi column filter, the right-click quick filters, and the "Find text on server" logic.