Josh Berkus wrote:
> On 4/2/09 8:48 AM, David E. Wheeler wrote:
>> On Apr 2, 2009, at 7:20 AM, Steven Lembark wrote:
>>
>>>>> Note that since the Internships are not required to be project code,
>>>>> we can also take student projects to contribute to our WWW
>>>>> infrastructure and other areas the project needs some work.
>>>
>>> Would introducing a Duration (i.e., time-series
>>> a'la Date, et al)) data type be considered useful?
>
> Jeff Davis has already done a lot of this work; it's on pgFOundry
> somewhere.
The data type itself is quite trivial. It's all the operators that are
more difficult to implement, and also immensely useful. That part is
still incomplete. I'd recommend a book called Temporal Data and the
Relational Model by C.J. Date, Hugh Darwen and Nikos Lorentzos for
anyone interested in this topic. That book gives a guideline on how the
data type and operators should behave.
I'd love to see that implemented. I volunteer to mentor if someone wants
to tackle it.
-- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com