Operators for Binary Expressions
Various logical, mathematical and string operators are provided to created queries using binary expressions.
Operator | Description and Examples | Datatypes | Result type |
---|---|---|---|
Relational Expression Operators | |||
=
|
equality
|
x and y can be any type | Boolean |
!=
|
inequality
|
x and y can be any type. | Boolean |
>
|
Greater than
Less than Greater than or equal to Less than or equal to
Generically known as comparison operators |
x and y must both be number types, or both be Datetime types. | Boolean |
Logical Operators | |||
and
or |
Logical (Boolean) and, or.
|
x and y must be Boolean | Boolean |
Mathematical Operators
Also used in the projection ( |
|||
*
|
Multiplication
|
x and y must both be numbers. | Either the type of x or y, whichever has the larger capacity. |
\
|
Division
|
x and y must both be numbers. | double |
mod
|
Remainder
|
x and y must both be numbers. | Either the type of x or y, whichever has the larger capacity. |
+
|
Addition
|
x and y must both be numbers. | Either the type of x or y, whichever has the larger capacity. |
-
|
Subtraction
|
x and y must both be numbers. | Either the type of x or y, whichever has the larger capacity. |
Postfix Operators | |||
[]
|
Array dereferencing, to access an array element.
|
x must be an array and y must be an int. | Type of the array element. |
.
|
For object graph traversal, to access a property
|
x must be an entity and y must be a property. | Type of y. |
@
|
For object graph traversal, to access an attribute
|
x must be an entity and y must be a attribute. | Type of y. |
String Operator | |||
||
|
String concatenation
|
x and y must be String | String |
like
|
The like operator matches all strings that match the regular expression provided in double quotes.
With the TIBCO cache provider, you can use
Results: TIBX, MSFT,
Results: MSFT
Results: TIBX
Results: TIBX
Results: JNJ, VMW, TIBX, HPQ, MSFT, HPQ |
String | Boolean |