Name
except — Returns a difference of two sets
Synopsis
sequence
except
(
|
set1 sequence , |
set2
sequence
); |
Description
The function returns an unordered sequence that consists of all distinct items from the first sequence that are missing in the second sequence.
Duplicate values from
set1
are removed, the decision whether two values duplicate each other is made according rules used by
distinct()
function.
Parameters
set1
Sequence that contains items that can occur in the resulting set.
set2
Sequence that contains items that can not occur in the resulting set.
Return Types
The function returns an unordered sequence of distinct values.