Esbach, Brandon <Esbachb@...> writes:
PostgreSQL treats LIKE queries as case-sensitive; so
to
make it case-insensitive you would have to use ilike (extra i in front of
like) to make it case-insensitive.
ILIKE is PostgreSQL specific. Two UPPERCASE will work on any database.