Is there a way to convert an int4 into a money? I have a few reports
that require format of int4 as a money(I didn't use money for money
because it's very difficult to convert money into other types it
seems)...
The only way I can figure out how to do it is a kludge, such as:
CREATE TABLE z(a int4, b money);
Fill a with appropriate values, then set b as "1". SELECT a*b as a FROM
z... And your done... But there should be some easier way to convert an
int4 into a money rather than mulitply it?
--David