On Tue, Dec 21, 2004 at 20:47:31 +0000, "Vladimir S. Petukhov" <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
