Re: Question about PARTIAL DATE type/s

Daniele Varrazzo <daniele.varrazzo@gmail.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