Corrupt indexes in PG12, how do I fix?

That could be. I think that the leading % is enough, but I could be wrong.

3 Likes

Correct.

See, for example:

3 Likes

But… all settings are in lowercase, so just using lowercase in the query does not need ilike ?

6 Likes

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.