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: 2007-10-31 19:34:08
Message-ID: 377646.35562.qm@web57707.mail.re3.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2007-10-31 19:51:55 Re: timestamp problem
Previous Message Michael Glaesemann 2007-10-31 17:51:57 Re: timestamp problem