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.