Re: Division of intervals.

Joshua Moore-Oliva <josh@chatgris.com> writes:
> I attempted
> SELECT age(now(), timestamp '1957-06-13') / interval '1 month';
> and got the error
> ERROR:  Unable to identify an operator '/' for types 'interval' and 'interval'

I'm not sure division of intervals is sensible --- consider the
recently-pointed-out issues about variable length of months, etc.

Does this do what you want?

regression=# SELECT extract(year from age(now(), timestamp '1957-06-13'));
 date_part
-----------
        45
(1 row)

regression=# SELECT extract(month from age(now(), timestamp '1957-06-13'));
 date_part
-----------
         9
(1 row)

regression=# SELECT extract(year from age(now(), timestamp '1957-06-13')) *12
regression-# + extract(month from age(now(), timestamp '1957-06-13'));
 ?column?
----------
      549
(1 row)


            regards, tom lane