Re: How do you compare contents of two tables using 2 pk

From: "Joel Fradkin" <jfradkin(at)wazagua(dot)com>
To: "'Kent Anderson'" <kenta(at)ezyield(dot)com>, "'Pgsql-Sql(at)Postgresql(dot) Org'" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: How do you compare contents of two tables using 2 pk
Date: 2005-02-24 17:36:16
Message-ID: 005601c51a97$58bf67d0$797ba8c0@jfradkin
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Couldn’t you do a select * from t1 where not in uniquevar (select uniquevar
from t2)?
Or do a join and select on a value in t2 being null.

Joel Fradkin
 

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2005-02-24 17:50:29 Re: Junk queries with variables?
Previous Message Richard Huxton 2005-02-24 17:28:42 Re: Junk queries with variables?