| 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: | 42A89CA1.2050806@commandprompt.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| 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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matt Miller | 2005-06-09 20:05:02 | ERROR: cannot cast type text to bit varying |
| Previous Message | John Browne | 2005-06-09 19:37:15 | monetary data |