Aggregates

Subtopics

One of the simple, but powerful built-in functions is count. It's a function that takes a set of anything as its input and returns the number of elements in that set. Try counting all Content objects:

Input

Run

select count(Content);

select count(Content);

Output Objects

Press the 'Run' button to evaluate the input

Since all values in EdgeDB can be compared to other values of the same type you can find a "minimum" and a "maximum" value by using min and max, respectively:

Input

Run

select min({-3, 2, 1, -3});

select min({-3, 2, 1, -3});

Output Objects

Press the 'Run' button to evaluate the input

Input

Run

# the strings are compared lexicographically
select max(Person.name);

# the strings are compared lexicographically
select max(Person.name);

Output Objects

Press the 'Run' button to evaluate the input

Another pair of useful functions is array_agg and array_unpack which convert a set to an array and vice versa, respectively. Try them out:

Input

Run

select array_agg({-3, 2, 1, -3});

select array_agg({-3, 2, 1, -3});

Output Objects

Press the 'Run' button to evaluate the input

Prev Next