Re: How to design schema for time information

From: <>
Date: Sat, 8 Mar 2008 16:16:36 -0800 (PST)
Message-ID: <>

On Mar 7, 9:44 pm, "Shakespeare" <> 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.

  • Phil
Received on Sat Mar 08 2008 - 18:16:36 CST

Original text of this message