Posted by --CELKO-- on 11/19/32 11:29

>> We have no idea what business problem PromisedOyster has, so it's quite pointless to cram that calender table down this throat. <<

Okay, what are the odds that he lives in a world without time and aksed
this question?

>> Particularly, since when we know he does not have have privileges to create tables anyway.<<

So the right answer to temporal problems change depending on your
privileges? No, it does not. The abiltiy to do the right thing might
change depending on your privileges, but the answer does not. And as a
professional it is your duty to speak the truth.

>> Simply your table of numbers, but with dates. <<

When I do a Sequence table, I often have other columns such as number
names, a random number, a weird function, etc..

>> Holidays etc? Yes, there is table for this as well, but it only has entries for Mon-Fri that are not business days, and it's maintained by users. <<

Keeping temporal data in two places as you proposed sounds like
attribute splitting. Can you tell me why a holiday is a logically
different kind of thing from anyother date?

[Back to original message]