Daniele Varrazzo <daniele.varrazzo@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
