| 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: | Whole Thread | Raw Message | 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
| 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 |