• Expression: <value> <> [<lower>, <upper>]
• Operand: string, number, time

Constant

Example: Judge whether "abc" is in the open interval ["abc", "123"]

return "abc" <> ["abc", "123"]

0

Function

Example: Judge whether PI is in the open interval [3.14, 3.15]

with [3.14, 3.15] as a
return pi() <> [a[0], a[1]]

1

Alias

Example: Judge each row of an alias whether it is in the open interval [2, 4]

uncollect [1,2,3,2,2] as a
return a <> [2, 4]

0
0
1
0
0

Sample graph: (to be used for the following examples)

create().node_schema("professor").node_schema("student")
create().node_property(@*, "age", int32).node_property(@*, "email", string)
insert().into(@professor).nodes([{_id:"P001",_uuid:1,age:53,email:"[email protected]"},{_id:"P002",_uuid:2,age:27,email:"[email protected]"}])
insert().into(@student).nodes([{_id:"S001",_uuid:3,age:27,email:"[email protected]"},{_id:"S002",_uuid:4,age:20,email:"[email protected]"},{_id:"S003",_uuid:5,age:25,email:"[email protected]"}])

Property

Example: Find nodes whose age is in the open interval [25, 35]

find().nodes({age <> [25, 35]}) as n
return n{*} 

|--------------- @professor --------------|
|  _id  | _uuid |  age  |       email     |
|-------|-------|-------|-----------------|
| P002  |   2   |  27   | [email protected] |

|---------------- @student ---------------|
|  _id  | _uuid |  age  |       email     |
|-------|-------|-------|-----------------|
| S001  |   3   |  27   | [email protected]   |

Example: Find nodes of @professor, whose age is in the open interval [25, 35]

find().nodes({@professor.age <> [25, 35]}) as n
return n{*} 

|--------------- @professor --------------|
|  _id  | _uuid |  age  |       email     |
|-------|-------|-------|-----------------|
| P002  |   2   |  27   | [email protected] |