| Lists: | pgsql-general |
|---|
| From: | John Browne <jkbrowne(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | monetary data |
| Date: | 2005-06-09 19:37:15 |
| Message-ID: | [email protected] |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-general |
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...
| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | John Browne <jkbrowne(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: monetary data |
| Date: | 2005-06-09 19:46:41 |
| Message-ID: | [email protected] |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-general |
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?
>
> http://archives.postgresql.org
--
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/