On Sun, Oct 7, 2012 at 3:03 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > 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.) Didn't realize intervals store months/days info separately: I thought an interval was just a vector in the timestamp space. Nice surprise. -- Daniele -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
