COMPARISON Functions
All functions > COMPARISON
All functions in the COMPARISON category.
Equality
| Function | Description |
|---|---|
= [equals] | Returns TRUE if the first value equals the second value |
!= [not] | Returns TRUE if the first value does not equal the second value |
IS NULL | Returns TRUE if the expression evaluates to NULL. |
IS NOT NULL | Returns TRUE if the expression does NOT evaluate to NULL. |
DISPLAYS AS | Returns TRUE if two values are not distinct, treating NULL values as comparable. |
IS NOT DISTINCT FROM | Returns TRUE if two values are not distinct, treating NULL values as comparable (SQL-standard... |
NOT DISPLAYS AS | Returns TRUE if two values are distinct, treating NULL values as comparable. |
IS DISTINCT FROM | Returns TRUE if two values are distinct, treating NULL values as comparable (SQL-standard spelling). |
Ordering
| Function | Description |
|---|---|
< [less] | Returns TRUE if the first value is strictly less than the second value |
<= [less] | Returns TRUE if the first value is less than or equal to the second value |
> [greater] | Returns TRUE if the first value is strictly greater than the second value |
>= [greater] | Returns TRUE if the first value is greater than or equal to the second value |
BETWEEN | Returns TRUE if a value is within a specified range (inclusive) |
NOT BETWEEN | Returns TRUE if a value is NOT within a specified range (inclusive). |
LEAST(...) | Returns the least (minimum) value from a list of arguments. |
GREATEST(...) | Returns the greatest (maximum) value from a list of arguments. |
Pattern Matching
| Function | Description |
|---|---|
LIKE | Returns TRUE if a string matches a specified pattern with wildcards. |
NOT LIKE | Returns TRUE if a string does NOT match a specified pattern with wildcards. |
LIKE multiple | Case-sensitive or case-insensitive pattern matching: LIKE / ILIKE with ANY, ALL, or NONE... |
Set Operations
| Function | Description |
|---|---|
IN | Returns TRUE if a value exists in a list of values. |
NOT IN | Returns TRUE if a value does NOT exist in a list of values. |
Summary
- Functions in COMPARISON: 21
This documentation is automatically generated from the FeatureMesh registry.
On this page