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

Fields

No fields configured for issues without a type.

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions