I wrote:
Note that IN and EXCEPT are essentially set operators - if you have
duplicates in either table, you might not get what you expect.
If what you want is the =bag= difference of the two tables, you'll
have to do something more complicated.
and then I immediately saw Pandurangan's message indicating that ALL
can be used to turn the set operators into bag operators, e.g., EXCEPT
ALL. Cool! (And not complicated at all.)
- John D. Burger
MITRE
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster