O'Reilly logo
  • Martin Bell thinks this is interesting:

ILIKE for Case-Insensitive Search

PostgreSQL is case-sensitive. However, it does have mechanisms in place to do a case-insensitive search. You can apply the upper function to both sides of the ANSI LIKE operator, or you can simply use the ILIKE (~) operator found only in PostgreSQL:



Cover of PostgreSQL: Up and Running, 2nd Edition


Case insensitive search in PostgresSQL