Date: Sun, 17 Jun 2007 11:54:41 -0400
From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-sql@postgresql.org
Subject: Re: joining a table whose name is stored in the primary record
Message-ID: <20070617155441.GB13671@phlogiston.dyndns.org>
References: <4674F357.5040409@bucksvsbytes.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <4674F357.5040409@bucksvsbytes.com>
User-Agent: Mutt/1.5.9i

On Sun, Jun 17, 2007 at 04:39:51AM -0400, John Gunther wrote:
> functions and using subqueries without success. I think I need someone 
> to point me in the right conceptual direction.

Well, the right SQL-esque conceptual direction is not to have
different tables at all.  That's not a very normal-form thing to do,
because the data has been broken into pieces dependent on the data
itself, rather than the kind of data it is.

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
In the future this spectacle of the middle classes shocking the avant-
garde will probably become the textbook definition of Postmodernism. 
                --Brad Holland