Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
What data type best used for money
- From: niccguard-dev(at)yahoo(dot)com
- To: pgsql-novice(at)postgresql(dot)org
- Subject: What data type best used for money
- Date: Wed, 31 Oct 2007 12:34:08 -0700 (PDT)
Creating a database where monetary values will be stored and of course retrieved with calculations. What data types are best to use in this sort of environment?
money is limited in quantity
numeric - documentation states "arithmetic on numeric values is very slow compared to the integer types"
Just wanted to get some feedback on what seems to be the better way to go and 'why'.
Thanks,
Aaron
- Follow-Ups:
- Re: What data type best used for money
- From: Phillip Smith
- Re: What data type best used for money
- Prev by Date: Re: timestamp problem
- Next by Date: Re: timestamp problem
- Previous by thread: Problem with createdb
- Next by thread: Re: What data type best used for money
- Indexes: