Operators
Operators are lowercase and prefixed with an underscore (β_β) character.
_is_null | Is null |
_eq | Equals |
_neq | Not equal |
_gt | Greater than |
_gte | Greater than or equal |
_lt | Less than |
_lte | Less than or equal |
_in | Part of a list |
_nin | Not part of list |
_like | Matches case-sensitive pattern |
_ilike | Matches case-insensitive pattern |
_nlike | Does not match case-sensitive pattern |
_nilike | Does not match case-insensitive pattern |
_similar | Matches the pattern using the SQL standard's definition of a regular expression |
_nsimilar | Does not match pattern using the SQL standard's definition of a regular expression |
_or | Matches either case |
_and | Matches both cases |
_regex | Matches a regular expression (case-sensitive) |
_iregex | Matches a regular expression (case-insensitive) |
_nregex | Does not match a regular expression (case-sensitive) |
_niregex | Does not match a regular expression (case-isensitive) |
If you have any further questions please reach out to us at Support