Re: Division of intervals.

Joshua Moore-Oliva <josh(at)chatgris(dot)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