Re: Dynamic table

Поиск
Список
Период
Сортировка
От A B
Тема Re: Dynamic table
Дата
Msg-id dbbf25900906160556v24826811m1e337009ef56c7a4@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Dynamic table  (Greg Stark <gsstark@mit.edu>)
Ответы Re: Dynamic table  (A B <gentosaker@gmail.com>)
Список pgsql-general


2009/6/16 Greg Stark <gsstark@mit.edu>
On Tue, Jun 16, 2009 at 12:21 PM, A B<gentosaker@gmail.com> wrote:

I don't think think it's fair to call this EAV actually. It sounds
like the integers are a collection of things which represent the same
thing. Ie, they're all bank balances or all distances driven, just for
different time periods. Storing all objects representing the same
thing in the same column is just a regular normalized table, not EAV.

You might want to consider partitioning the table of integers by type
to facilitate dropping the old ones. But that's an administrative
trick, not a fundamental schema design decision.

Unfortunatly there is no "type" here. One can make no distinction between the integers and one can not tell when they are added or dropped.

В списке pgsql-general по дате отправления:

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: Dynamic table
Следующее
От: A B
Дата:
Сообщение: Re: Dynamic table