Re: compare 2 tables in sql - Mailing list pgsql-sql

From Jonah H. Harris
Subject Re: compare 2 tables in sql
Date
Msg-id 36e682920803201221l7f4775b9r2fe0d7c23a40a83a@mail.gmail.com
Whole thread Raw
In response to compare 2 tables in sql  ("Tena Sakai" <tsakai@gallo.ucsf.edu>)
List pgsql-sql
On Thu, Mar 20, 2008 at 1:44 PM, Tena Sakai <tsakai@gallo.ucsf.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.harris@enterprisedb.com
Edison, NJ 08837 | http://www.enterprisedb.com/


pgsql-sql by date:

Previous
From: "Jan Peters"
Date:
Subject: Re: Rollback locks table - why?
Next
From: "Tena Sakai"
Date:
Subject: Re: compare 2 tables in sql