Postgres Pro
Downloads
Home   >   mailing lists

Re: joining a table whose name is stored in the primary record - Mailing list pgsql-sql

From Andrew Sullivan
Subject Re: joining a table whose name is stored in the primary record
Date
Msg-id 20070617155441.GB13671@phlogiston.dyndns.org
Whole thread Raw
In response to joining a table whose name is stored in the primary record  (John Gunther <postgresql@bucksvsbytes.com>)
Responses Re: joining a table whose name is stored in the primary record  (John Gunther <postgresql@bucksvsbytes.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: joining a table whose name is stored in the primary record
Next
From: Jeff Frost
Date:
Subject: separating improperly grouped page views