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:
I think it could be simpler now, with generate_series() for some intervals.
In response to
pgsql-hackers by date
|Next:||From: Josh Berkus||Date: 2011-06-27 18:08:58|
|Subject: Commitfest 2001-06: 10 days in|
|Previous:||From: Robert Haas||Date: 2011-06-27 18:05:23|
|Subject: Re: per-column generic option|