Re: A better BETWEEN for DATEs, TIMEs and TIMESTAMPs?

From: Reg Me Please <regmeplease(at)gmail(dot)com>
To: Jeff Davis <pgsql(at)j-davis(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: A better BETWEEN for DATEs, TIMEs and TIMESTAMPs?
Date: 2009-01-14 21:59:39
Message-ID: 200901142259.39548.regmeplease@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

I got some compilation error (I run Ubuntu) that needs investigation.
From the documentation it seems exactly what I was looking for!

I would put this thing among the official contribs: any chance?

--
Fahrbahn ist ein graues Band
weisse Streifen, grüner Rand

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Davis 2009-01-14 22:10:26 Re: A better BETWEEN for DATEs, TIMEs and TIMESTAMPs?
Previous Message Tom Lane 2009-01-14 21:55:57 Re: Odd duplicate database