Define maximum time increment. - Mailing list pgsql-general

I am attempting to extract the number of months, or sometimes minutes from an
interwith with age for example.

SELECT age(timestamp '1957-06-13 10:57');

returns "45 years 8 mons 24 days 13:03"

while

SELECT EXTRACT (minutes FROM age(timestamp '1957-06-13 10:57') );

returns just "3"

Is there a way to define per session the MAXIMUM time increment for an
interval?  So that It would return the total number of minutes since that
date?


Basically, I think should could be achieved by some sort of interval
formatting functions...  something along the lines of

SELECT EXTRACT (minutes FROM ( age(timestamp '1957-06-13 10:57') LIMIT minutes
) );

I really need this functionality for a number of examples just no the minutes.
I know i could extract epoch, divide by 60 and I'm fine.  But I also needs
months...  then I need to extracts months plus years * 12..   I also have a
need for days...  then that gets even messier...


Any hints or even vague ideas are very welcome!

Josh.