"D'Arcy J.M. Cain" <darcy@druid.net> writes:
> That said, I wonder if there is another answer to this question.
> Perhaps the functions in cash.c can be pulled out and made into
> external functions that can be fed an int (long) and output the desired
> format. That way we could use the existing int or long type but
> convert manually on I/O. Let people choose whether they want the
> simplification of the money type or the standardization allowed by just
> using the functions.
Long term I liked the idea from a few years ago of having a "default format"
which would be attached to a column just like a default collation can be
attached. Then you can declare your currency columns as regular integers but
mark them as being formatted as currency by default.
pg_dump would presumably explicitly override the default and format the
integers as plain integers and restore the default format string as part of
its DDL.
-- Gregory Stark EnterpriseDB http://www.enterprisedb.com