Relation:difference

Uses the two relations top of the stack and creates a new relation that containts the tuplein the first relation, but not in the second . The tuples must have the same columns.

Description

difference

Parameters

None.

Examples

Using the sample relation films.csv

read "films.csv"
dup
select director == "Godard"
difference

film director year
Tirez sur le pianiste Truffaut 1960
Cléo de 5 à 7 Varda 1962
Jules et Jim Truffaut 1962
Die verlorene Ehre der Katharina Blum von Trotta 1975
Der starke Ferdinand Kluge 1976
Sans toi ni loi Varda 1985

Comments

Tuples in both relatins must have the same columns, but not necessarily in the same order, because the order of the columns does not matter.

See also

union, intersection