monetary data
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...
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,
Joshua D. Drake
Thanks for any info...
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/