Re: Question about PARTIAL DATE type/s

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(dot)varrazzo(at)gmail(dot)com>wrote:

> On Sun, Oct 7, 2012 at 3:03 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> > Daniele Varrazzo <daniele(dot)varrazzo(at)gmail(dot)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
>