Home > mailing lists

Re: How do you compare contents of two tables using 2 pk - Mailing list pgsql-sql

From	Joel Fradkin
Subject	Re: How do you compare contents of two tables using 2 pk
Date	February 24, 2005 20:32:15
Msg-id	005601c51a97$58bf67d0$797ba8c0@jfradkin Whole thread Raw
In response to	How do you compare contents of two tables using 2 pk ("Kent Anderson" <kenta@ezyield.com>)
List	pgsql-sql

Tree view

Couldnt 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

pgsql-sql by date:

From: Richard Huxton
Date: 24 February 2005, 20:28:57
Subject: Re: Junk queries with variables?

From: Tom Lane
Date: 24 February 2005, 20:50:29
Subject: Re: Junk queries with variables?

Re: How do you compare contents of two tables using 2 pk - Mailing list pgsql-sql

Previous

Next