I started looking into making my “blog” software use case-insensitive searching. I thought that would make the “Search” facility for this site much more powerful.
The secret to Postgresql case-insensitive searching with SQL
SELECT queries is to use regular expressions. If you’re used to standard Unix/POSIX regular expressions, the implementation is pretty easy as well. Instead of using the standard database
LIKE operator, the solution is to use the Postgres