Daniele Varrazzo <daniele.varra...@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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
