Wade Klaver <archeron(at)wavefire(dot)com> writes:
> I guess what I am trying
> to say is that the date_part() call is how you determine what you are
> asking... If I want to get the number of years, it shouldn't matter if my
> interval is '1 year, 1 month' or '396 days', they both contain 1 year.
I think you missed the point. If I want to get the number of months,
it's clear what the answer is for an interval of '1 year', but not at
all clear what the answer is for an interval of '60 days'. Months and
days don't have a fixed conversion factor.
regards, tom lane