Re: generate_series() Interpretation

On Mon, Jun 27, 2011 at 1:38 PM, David E. Wheeler <david(at)kineticode(dot)com>wrote:

>
> Yeah, which is why I said it was subject to interpretation. Of course
> there's no way to tell generate_series() which to use, which is what I
> figured.
>

generate_series() is doing exactly what it was designed to do, the
imprecision regarding adding '1 month' to something that may or may not have
been intended to be 'last day of the month' is a limitation in the interval
code.

One way to change this would be to implement another interval type such as
'full_month' which would take a date that is know to be the last day of the
month and make it the last day of the appropriate month. If the starting
date is NOT the last day of a month, the existing logic would suffice.

Or you can do as I have done and create your own last_day() function that
takes any date and makes it the last day of that month, and apply it to the
output of generate_series();
--
Mike Nolan
nolan(at)tssi(dot)com