John Browne wrote:
I was just curious how you guys implement storage / calculation of
monetary data in postgresql. The docs say to use the numeric data
type, but I'm curious what precision is typically defined for storing
monetary data in the numeric data type.
We use numeric(10,2)
Sincerely
I was just curious how you guys implement storage / calculation of
monetary data in postgresql. The docs say to use the numeric data
type, but I'm curious what precision is typically defined for storing
monetary data in the numeric data type.
Thanks for any info...
---(en
Phuong Ma <[EMAIL PROTECTED]> writes:
> I read this from the 7.1 documentation:
> 3.2. Monetary Type
> The money type may become a locale-aware
> layer over the numeric type in a future release.
> The money type stores U.S.-style currency with fixed decimal point
> representation. If Postgres i