On Fri, 2012-08-03 at 10:42 -0700, Jeff Davis wrote: > On Fri, 2012-08-03 at 17:06 +0200, Andreas Kretschmer wrote: > > great feature, but i can't find a TIMERANGE, i want to store time-ranges, for > > instance [10:00:00,16:00:00), how can i do that? > > CREATE TYPE timerange AS RANGE ( subtype = time ); > > That's the simple answer. I believe we discussed including this as a > built-in range type at some point, but decided against it. I can't > remember the reason right now. Time of day is a cycle (I forget who pointed this out), so a limit of 24:00:00 is fairly restrictive. It happens that daytime ranges like [14:00,15:00) are more common; but it doesn't seem unreasonable to say [22:00,02:00) either. So, an interpretation where time of day has a total order is only useful really for a daytime schedule (which is still useful, but perhaps not general enough to include in core). We might be able to make it work as ranges within a 24-hour cycle, but that will require more thought. Regards, Jeff Davis -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
