On Jun 27, 2011, at 11:03 AM, Kevin Grittner wrote: > It is precisely to support such fancy things that some products > support a more abstract date type which allows 31 days in any month, > and then normalizes to real dates as needed. The PostgreSQL > developer community has generally not been receptive to such use > cases. I think you need to iterate through month intervals and add > those to the starting date for now. If you want to start with the > last day of a month with less than 31 days, you may need to back up > a month or two to find a suitable month and offset your intervals by > the appropriate number of months. > > I'd bet that if you encapsulate all that in a PostgreSQL function, > you're not the only one who would find it useful.
Yeah, did that a while ago: http://www.justatheory.com/computers/databases/postgresql/recurring_events.html I think it could be simpler now, with generate_series() for some intervals. Best, David -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers