Re: A better BETWEEN for DATEs, TIMEs and TIMESTAMPs?
От | Reg Me Please |
---|---|
Тема | Re: A better BETWEEN for DATEs, TIMEs and TIMESTAMPs? |
Дата | |
Msg-id | 200901142259.39548.regmeplease@gmail.com обсуждение исходный текст |
Ответ на | Re: A better BETWEEN for DATEs, TIMEs and TIMESTAMPs? (Jeff Davis <pgsql@j-davis.com>) |
Ответы |
Re: A better BETWEEN for DATEs, TIMEs and TIMESTAMPs?
|
Список | 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
В списке pgsql-general по дате отправления: