Operators

Subtopics

The are 3 logical operators in EdgeQL: and, or, and not. These only work on boolean values:

Input

Run

select true and false;

select true and false;

Output Objects

Press the 'Run' button to evaluate the input

However, there are other operators that produce a boolean result, such as various equality and inequality comparison operators: =, !=, >, <, >=, <=. These can be combined with logical operators:

Input

Run

select 1 < 3 and 3 <= 100;

select 1 < 3 and 3 <= 100;

Output Objects

Press the 'Run' button to evaluate the input

Note that it's not just numeric types that can be compared to each other, but also all other scalar types as well as arrays and tuples. However, both operands must be of the same type in order to be compared (str can be compared to other str, but not to int64 or a bool):

Input

Run

select 'Hello' != 'world';

select 'Hello' != 'world';

Output Objects

Press the 'Run' button to evaluate the input

Input

Run

# strings are ordered lexicographically
select 'Hello' < 'world';

# strings are ordered lexicographically
select 'Hello' < 'world';

Output Objects

Press the 'Run' button to evaluate the input

Input

Run

# ordered by value
select <duration>'15m' < <duration>'1h';

# ordered by value
select <duration>'15m' < <duration>'1h';

Output Objects

Press the 'Run' button to evaluate the input

Prev Next