Hi Jonah, > Still, you should UNION the result of > both exceptions into a single result set.
Great suggestion. Many thanks. Regards, Tena Sakai [EMAIL PROTECTED] -----Original Message----- From: Jonah H. Harris [mailto:[EMAIL PROTECTED] Sent: Thu 3/20/2008 12:21 PM To: Tena Sakai Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] compare 2 tables in sql On Thu, Mar 20, 2008 at 1:44 PM, Tena Sakai <[EMAIL PROTECTED]> 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 | [EMAIL PROTECTED] Edison, NJ 08837 | http://www.enterprisedb.com/
