Re: [libreoffice-users] Base/HSQL table with more than two dimensions?

On 2020-06-24 06:39, Dave Howorth wrote:
> > ... It should be possible to do a table of three dimensions, of
> > which the third dimension is the year {A,B,C,D} in the cycle, so
> > that one could compare the readings for any given day across all
> > years. But I don't see how to extend tables into three (as in this
> > case) or more dimensions. Can someone point me in the right
> > direction?  [It seems like this kind of database design issue
> > should be common to a lot of domains.]
>
> Every extra field added to a record creates another dimension in data
> space. So you just need to add a column called, say, year that can take
> each of the values 'A', 'B', 'C' or 'D' and then add that field to your
> SELECT statement.

Oh, of course: an extra column for each extra dimension.  Thanks, Dave.


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy