Comparison Functions and Operators

Name Description
= Assign a value
/ Division operator
== Equal operator
!= Not equal operator
< Less than operator
<= Less than or equal operator
- Minus operator
% Modulo operator
+ Addition operator
* Multiplication operator
- Change the sign of the argument
udf_is_in() Whether a value is within a set of values

Comparison operations result in a value of true and false.

  • ==

Equal. String comparisons are case-sensitive. Values of different types are not equal.

nebula> YIELD 'A' == 'a';
==============
| ("A"=="a") |
==============
| false |
--------------

nebula> YIELD '2' == 2;
[ERROR (-8)]: A string type can not be compared with a non-string type.
  • >

Greater than:

nebula> YIELD 3 > 2;
=========
| (3>2) |
=========
| true |
---------

Greater than or equal to:

nebula> YIELD 2 >= 2;
[ERROR (-8)]: A string type can not be compared with a non-string type.
  • <

Less than:

nebula> YIELD 2.0 < 1.9;
=======================
| (2.000000<1.900000) |
=======================
|false |
-----------------------

Less than or equal to:

nebula> YIELD 0.11 <= 0.11;
========================
| (0.110000<=0.110000) |
========================
|true |
------------------------
  • !=

Not equal:

nebula> YIELD 1 != '1';
A string type can not be compared with a non-string type.
  • udf_is_in()

Returns true if the first value is equal to any of the values in the list, otherwise, returns false.

nebula> YIELD udf_is_in(1,0,1,2);
======================
| udf_is_in(1,0,1,2) |
======================
| true               |
----------------------

nebula> GO FROM 100 OVER follow WHERE udf_is_in($$.player.name, "Tony Parker"); /* This example might not work because udf_is_in might be changed in the future.*/
===============
| follow._dst |
===============
| 101         |
---------------

nebula> GO FROM 100 OVER follow YIELD follow._dst AS id | GO FROM $-.id OVER follow WHERE udf_is_in($-.id, 102, 102 + 1);
===============
| follow._dst |
===============
| 100         |
---------------
| 101         |
---------------