I’ve got into a situation with PG I’ve never been into before. There is a financial reports table, containing some description of a transaction, with columns like date, amount and comment. And this comment field is often used to search for something case-insensitively. This is done best using where lower(comment) like ‘%some words%’ using trigram…
