Re: joining a table whose name is stored in the primary record

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: joining a table whose name is stored in the primary record
Дата
Msg-id 20070617155441.GB13671@phlogiston.dyndns.org
обсуждение исходный текст
Ответ на joining a table whose name is stored in the primary record  (John Gunther <postgresql@bucksvsbytes.com>)
Ответы Re: joining a table whose name is stored in the primary record  (John Gunther <postgresql@bucksvsbytes.com>)
Список pgsql-sql
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 по дате отправления:

Предыдущее
От: Andreas Kretschmer
Дата:
Сообщение: Re: joining a table whose name is stored in the primary record
Следующее
От: Jeff Frost
Дата:
Сообщение: separating improperly grouped page views