On Tuesday 21 December 2004 21:21, Bruno Wolff III wrote:
> On Tue, Dec 21, 2004 at 20:47:31 +0000,
> "Vladimir S. Petukhov" <vladimir(at)sycore(dot)org> wrote:
> > Ok, this is a real example:
> > CREATE TABLE account (
> > val1 BIGINT NULL,
> > val2 BIGINT NULL,
> > ...
> > daypos SMALLINT NULL, -- Day position
> > hourpos SMALLINT NULL, -- Hour position
> > id INT NULL -- Link to the object
> > );
> That approach is reasonable but depending on what the val* columns mean
> you might each of those as a separate role. You didn't add a lot of
> information, but that they appear to be the same type suggests that you
> might want one row per value. But without knowing what they mean it is
> hard to say.
OK, i want to store ststistic information, ingoing/outgoing traffic,
ingoing/outgoing errors(val1-val4) for example...
Man's unique agony as a species consists in his perpetual conflict between
the desire to stand out and the need to blend in.
-- Sydney J. Harris
Now playing: (Воскресение) - Музыкант.mp3
AutoGenerated by fortune & xmms...
In response to
pgsql-general by date
|Next:||From: Greg Sabino Mullane||Date: 2004-12-22 01:05:43|
|Subject: ANNOUNCE: DBD::Pg 1.40 release candidate 1 request for testing|
|Previous:||From: Paul Tillotson||Date: 2004-12-22 00:09:39|
|Subject: tool for incrementally shrinking bloated tables|