Re: [GENERAL] monetary data

2005-06-09 Thread Joshua D. Drake
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

[GENERAL] monetary data

2005-06-09 Thread John Browne
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

Re: [GENERAL] monetary data type

2001-04-06 Thread Tom Lane
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