Sets

Subtopics

EdgeQL has a number of basic operators for sets. Two of these are union and distinct.

union simply merges two sets together. This may result in duplicate entries:

Input

Run

select {1, 2, 3, 4} union {1, 4, 5};

select {1, 2, 3, 4} union {1, 4, 5};

Output Objects

Press the 'Run' button to evaluate the input

Operators can be used more than once in a single statement:

Input

Run

select {1, 2, 3, 4} union {1} union {1, 2, 3, 4};

select {1, 2, 3, 4} union {1} union {1, 2, 3, 4};

Output Objects

Press the 'Run' button to evaluate the input

distinct gets rid of duplicate entries producing a proper set:

Input

Run

select distinct ({1, 2, 3, 4} union {1, 4, 5});

select distinct ({1, 2, 3, 4} union {1, 4, 5});

Output Objects

Press the 'Run' button to evaluate the input

Sets cannot be elements of other sets in EdgeQL, making a nested syntax equivalent to a union. This is also consistent with the notion that everything is a set, including singleton literal values:

Input

Run

select {1, {2}, {3, 4}};

select {1, {2}, {3, 4}};

Output Objects

Press the 'Run' button to evaluate the input

Input

Run

select {1, 2, 3, 4, {1, 4, 5}};

select {1, 2, 3, 4, {1, 4, 5}};

Output Objects

Press the 'Run' button to evaluate the input

Prev Next