Re: Dynamic table - Mailing list pgsql-general

From A B
Subject Re: Dynamic table
Date
Msg-id dbbf25900906160556v24826811m1e337009ef56c7a4@mail.gmail.com
Whole thread Raw
In response to Re: Dynamic table  (Greg Stark <gsstark@mit.edu>)
Responses Re: Dynamic table
List 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 by date:

Previous
From: Greg Stark
Date:
Subject: Re: Dynamic table
Next
From: A B
Date:
Subject: Re: Dynamic table