I suspected that this would be the answer. Thank you lots for your kind help, Daniele & Tom [?]
On 7 October 2012 16:46, Daniele Varrazzo <daniele.varra...@gmail.com>wrote: > On Sun, Oct 7, 2012 at 3:03 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > > 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.) > > Didn't realize intervals store months/days info separately: I thought > an interval was just a vector in the timestamp space. Nice surprise. > > -- Daniele >
<<03D.gif>>