X-Original-To: pgsql-sql-postgresql.org@postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id D74559FB223
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 11 Jul 2006 12:14:59 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 70844-05 for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 11 Jul 2006 12:14:56 -0300 (ADT)
X-Greylist: delayed 00:06:41.216412 by SQLgrey-
Received: from s2.yuriev.com (s2.yuriev.com [69.31.8.140])
	by postgresql.org (Postfix) with SMTP id D4CC49FB26A
	for <pgsql-sql@postgresql.org>; Tue, 11 Jul 2006 12:14:56 -0300 (ADT)
Received: (qmail 1270 invoked by uid 500); 11 Jul 2006 14:19:52 -0000
Date: Tue, 11 Jul 2006 10:19:52 -0400
From: alex-lists-pgsql@yuriev.com
To: pgsql-sql@postgresql.org
Subject: How to find entries missing in 2nd table?
Message-ID: <20060711141951.GA17936@s2.yuriev.com>
Reply-To: pgsql-sql@postgresql.org
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.4.1i
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200607/179
X-Sequence-Number: 25753

Hi,
	I realize I probably lost my marbles but I've been having a god
awful time with a single query:

control:
	....
	....
	controller_id	pk;


datapack:

	controller_id	fk;
	....
	....
	....

I need to get all entries from the table control that are not listed in
datapack.


Thanks,
Alex