Brian Knox <laotse@aol.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