Daniele Varrazzo <daniele(dot)varrazzo(at)gmail(dot)com> writes:
> Note: it exploits to_date() parsing '200013' as '2001-01', which is
> reasonable but haven't found documented and don't know how much
> reliable. Writing a safer "one month later" function is left as
> exercise.
Consider adding '1 month'::interval to the month start date.
(This function relies on text-munging way too much for my taste.
There's almost always a better way to do it than that.)
regards, tom lane