Name
union — Returns an union of two or more sets
Synopsis
sequence union ( |
set1 sequence , |
| set2 sequence ... , | |
setN sequence); |
Description
The function returns an unordered sequence that consists of all distinct items from all given sets.
All duplicates are removed, including duplicate occurrences of
same value in one sequence, thus the function works exactly as
distinct() when only
one parameter is passed.
Parameters
setI
Sequence that contains items of the resulting union.
Return Types
The function returns an unordered sequence of distinct values.