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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers