Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Tom LaneDate: 2007-10-31 19:51:55
Subject: Re: timestamp problem
Previous:From: Michael GlaesemannDate: 2007-10-31 17:51:57
Subject: Re: timestamp problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group