Skip to content

SQL: new ILIKE operator to case-insensitively compare strings #1032

Description

@gramian

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'

Metadata

Metadata

Assignees

Labels

enhancementNew feature or request

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions