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.