| From: | "John D(dot) Burger" <john(at)mitre(dot)org> |
|---|---|
| To: | "Stefano B(dot)" <stefano(dot)bonnin(at)comai(dot)to> |
| Cc: | PostgreSQL-general general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Finding missing records |
| Date: | 2006-01-27 14:14:09 |
| Message-ID: | 047d25b6327fefb2248fde4fa9fc9760@mitre.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matthew Henderson | 2006-01-27 14:21:31 | Re: Accessing an old database from a new OS installation. |
| Previous Message | Alexander Presber | 2006-01-27 14:11:13 | Re: TSearch2 / German compound words / UTF-8 |