Operators

Subtopics

All the basic arithmetical operators are available for the numeric types as you would expect:

Input

Run

select 1 + 23;

select 1 + 23;

Output Objects

Press the 'Run' button to evaluate the input

Input

Run

# 2 to the power of 5
select 2 ^ 5;

# 2 to the power of 5
select 2 ^ 5;

Output Objects

Press the 'Run' button to evaluate the input

Input

Run

# Square root of 2
select 2 ^ 0.5;

# Square root of 2
select 2 ^ 0.5;

Output Objects

Press the 'Run' button to evaluate the input

There's a caveat that you cannot mix limited and unlimited numerical scalars in any operation. This is done deliberately so that you cannot accidentally end up switching between these types and get results that are potentially not portable between EdgeDB and other systems that don't implement bigint or decimal:

Input

Run

# This is OK.
select 2n + 3.3n;

# This is OK.
select 2n + 3.3n;

Output Objects

Press the 'Run' button to evaluate the input

Input

Run

# This is also OK due to explicit cast.
select 2 + <float64>3.3n;

# This is also OK due to explicit cast.
select 2 + <float64>3.3n;

Output Objects

Press the 'Run' button to evaluate the input

Input

Run

# This is an error.
select 2.2 + 3.3n;

# This is an error.
select 2.2 + 3.3n;

Output Objects

Press the 'Run' button to evaluate the input

Prev Next