On Wed, 2009-01-14 at 11:40 +0100, Reg Me Please wrote: > Infact I always have managed ranges where the lower part is to be matched with > the ">=" comparison operator while the higher part is matched with the "<". > In other words, until now I've always encountered intervals of the > type "[...)" and not "[...]". > > Wouldn't it be nice to have a version of the BETWEEN operator which uses > such a kind of intervals? I think the best solution is to make first-class interval types (for time as well as other types). Those intervals can then have operators like "contains" and "contained by" which would solve your problem. Additionally, it would allow lots of other interesting operations, like overlaps and intersects. 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
