\set ECHO none
add_provenance

(1 row)
add_provenance

(1 row)
remove_provenance

(1 row)
q|a|b
first 1 with ties|1|1
first 1 with ties|1|2
first 1 with ties|1|3
(3 rows)
remove_provenance

(1 row)
q|a|b
offset 3 with ties|2|1
(1 row)
remove_provenance

(1 row)
q|a|b
except with ties|1|1
except with ties|1|2
(2 rows)