Re: How to design schema for time information
Date: Sat, 8 Mar 2008 16:16:36 -0800 (PST)
On Mar 7, 9:44 pm, "Shakespeare" <what..._at_xs4all.nl> wrote:
> Would it be possible to use the first 0 in to_dsinterval('0 09:00:00') to
> store the day as a number offset from e.g. monday? So for tuesday use
> to_dsinterval('1 09:00:00')? Do I understand this correctly?
You understand correctly, and yes, it would be possible. I'm not sure the result would be a better design in the sort of simple example that I used, but it might be useful if there were an arbitrary number of opening periods per day.