LESS - Comparison
Checks if lhs
is less than rhs
.
Details
This function can also be written as infix notation <lhs> < <rhs>
.
Input parameters
Name | Type | Optional | Description |
---|---|---|---|
lhs |
String/Number | False | |
rhs |
String/Number | False |
Output
Bool: True if lhs
< rhs
Usage
LESS(<lhs>, <rhs>)
Examples
Example 1
Query
LOAD tmp
AS ('': LESS(5, 2))
Result
false
Example 2
Query
LOAD tmp
AS ('': LESS(5, 5))
Result
false
Example 3
Query
LOAD tmp
AS ('': LESS("A", "B"))
Result
true