Re: compare 2 tables in sql

Hi Jonah,

> Still, you should UNION the result of
> both exceptions into a single result set.

Great suggestion. Many thanks.

Regards,

Tena Sakai
tsakai(at)gallo(dot)ucsf(dot)edu

-----Original Message-----
From: Jonah H. Harris [mailto:jonah(dot)harris(at)gmail(dot)com]
Sent: Thu 3/20/2008 12:21 PM
To: Tena Sakai
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] compare 2 tables in sql

On Thu, Mar 20, 2008 at 1:44 PM, Tena Sakai <tsakai(at)gallo(dot)ucsf(dot)edu> wrote:
> Just a postscript. It is important to check
> both ways. Because (sometimes) vice versa is
> not necessarily true. Case in point below:

Yes, I'm well aware of that. Still, you should UNION the result of
both exceptions into a single result set.

--
Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324
EnterpriseDB Corporation | fax: 732.331.1301
499 Thornall Street, 2nd Floor | jonah(dot)harris(at)enterprisedb(dot)com
Edison, NJ 08837 | http://www.enterprisedb.com/