Operators

Subtopics

EdgeQL Tutorial

Operators

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

Input

SELECT 1 + 23;

SELECT 1 + 23;

Run

Output

Press the 'Run' button to evaluate the input

Input

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

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

Run

Output

Press the 'Run' button to evaluate the input

Input

# Square root of 2
SELECT 2 ^ 0.5;

# Square root of 2
SELECT 2 ^ 0.5;

Run

Output

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

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

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

Run

Output

Press the 'Run' button to evaluate the input

Input

# 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;

Run

Output

Press the 'Run' button to evaluate the input

Input

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

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

Run

Output

Press the 'Run' button to evaluate the input

Prev Next