Not case-insensitive like

Negated case-insensitive pattern match comparison.

Returns true when the left string does not match the SQL ILIKE pattern on the right.

Category: comparison

SQL symbol: NOT ILIKE

Example

SELECT 'a' NOT ILIKE 'a';

Signatures

• blob NOT ILIKE blob → boolean
• blob NOT ILIKE varchar → boolean
• varchar NOT ILIKE blob → boolean
• varchar NOT ILIKE varchar → boolean

Types

• Left: blob, varchar
• Right: blob, varchar
• Result: boolean