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
Regards,
David