On Tue, Dec 21, 2004 at 20:47:31 +0000,
"Vladimir S. Petukhov" <vladimir@sycore.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.