On Wednesday 14 January 2009 22:38:07 Jeff Davis wrote: > On Wed, 2009-01-14 at 13:35 -0800, Jeff Davis wrote: > > 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. > > I wrote such an interval type here, called "period" (to avoid confusion > with the SQL INTERVAL type): > > http://pgfoundry.org/projects/temporal > > Regards, > Jeff Davis Jeff, I'll give your implementation a try and possibly a look to the code itself. I thought that was not just my personal opinion, though. -- Fahrbahn ist ein graues Band weisse Streifen, grüner Rand -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
