SQL: new ILIKE operator to case-insensitively compare strings

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'

Added by #1033 .

chore(deps): bump the github-actions group with 4 updates [skip ci]

chore(deps): bump the github-actions group across 1 directory with 8 …

Navigation Menu