On Thu, 28 Apr 2005, David Wheeler wrote:
On Apr 28, 2005, at 10:48 PM, Dave Rolsky wrote:
What I'd really like to see is some way to query both single events and recurring events within a given timeframe, all in one query that returns a sorted array of occurrences.
I haven't tried it (yet), but you might want to check out the INTERVAL data type in PostgreSQL.
http://www.postgresql.org/docs/current/static/datatype-datetime.html
This data is basically the same as a DateTime::Duration. But I want to store a recurrence (in other words a set).
-dave
/*=================================================== VegGuide.Org www.BookIRead.com Your guide to all that's veg. My book blog ===================================================*/