Brian Knox <laotse(at)aol(dot)net> writes:
> Is it possible within pl/pgsql, to convert an integer to an interval in
> months? IE, if num_months is an INT set to 48, can it be converted to an
> interval?
Sure, just multiply by the appropriate interval value:
regression=# select 48 * '1 month'::interval;
?column?
----------
4 years
(1 row)
regards, tom lane