Jeff Davis <pgsql@xxxxxxxxxxx> wrote: > On Fri, 2012-08-03 at 17:06 +0200, Andreas Kretschmer wrote: > > Hi all, > > 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 ); Thx. > > 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. Okay, but is it possible to write down this as an example in the documentation? I think there are a LOT of possible use-cases for TIMERANGE ... (or, better, include it as build-in ...) Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknown) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889° -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
