As an alternative to manually lower case string comparison operands, a case insensitiveILIKE is a convenient operator to have,
so instead of:
SELECT name FROM doc WHERE name.toLowerCase() LIKE 'jOe'.toowerCase()
the ILIKE operator simplifies to:
SELECT name FROM doc WHERE name ILIKE 'jOe'
As an alternative to manually lower case string comparison operands, a case insensitive
ILIKEis a convenient operator to have,so instead of:
the
ILIKEoperator simplifies to: