"D'Arcy J.M. Cain" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
