Operators for Other Expressions

Event Stream Processing also provide few operators for queries other than unary and binary expressions.

Operators for Other Expressions in Queries
Operator Description and Examples Datatypes Result type
between and Between operator for range expressions. Range is inclusive.

x between y and z

x and y must all be number types, or all be Datetime types. Boolean
in() Inclusion operator. Checks if an expression is in a group of items.

x in (y1, y2, ..., yn)

Any Boolean
$ Bind variable prefix. 
$name
 name has no type. It is just a label. The type of $name is determined by its surrounding expression. For example, in the expression: 
($minimum + 14.58)

$minimum is a bind variable of type double.