Re: [HACKERS] money data type and conversions]

Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> writes:
> Maybe we will have to add '$' symbols to a special case of the numeric
> type, or add a function to output numeric in money format?

I like the last idea (add a formatting function), because it's simple,
self-contained, and doesn't force any solutions on anyone. Don't want
any decoration on your number? Just read it out. Don't like the
decoration added by the formatting function? Write your own function.
No table reconstruction required. With a data-type-driven approach,
changing your mind is painful because you have to rebuild your tables.

We'd probably also want an inverse function that would strip off the
decoration and produce a numeric, but that's easy too...

regards, tom lane