Brian Knox <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
