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.