Returns TRUE if x is less than y. Otherwise, this function returns FALSE. You can compare an array or cluster of a data type to a scalar of the same data type and produce an array or cluster of Booleans. The connector pane displays the default data types for this polymorphic function.
![]() |
x and y must be of the same type. |
![]() |
When you compare arrays, x < y? is a scalar in Compare Aggregates mode and a Boolean array in Compare Elements mode (default). You can set this function to Compare Aggregates or Compare Elements mode. |