Re: Money casting too liberal? - Mailing list pgsql-general

From D'Arcy J.M. Cain
Subject Re: Money casting too liberal?
Date
Msg-id 20130330094738.63f04d0f@imp
Whole thread Raw
In response to Re: Money casting too liberal?  (Julian <tempura@internode.on.net>)
List pgsql-general
On Sat, 30 Mar 2013 20:36:22 +1100
Julian <tempura@internode.on.net> wrote:
> The comparisons with timezones ends when it comes to exchange rates.

The only comparison I made with time and time zones was in how the
column type can be refined when it is created.

> With a current WIP. I'm starting to think that numeric is probably
> overkill for storing monetary values as well (are we going to go much
> more than 6 decimal places? and thats just for storing the rates...).
>
> Now considering just using integers. All the formatting of the input
> and display for output is done in the front end, just don't make a
> mistake there.

Yes, that's exactly why the money type exists.

--
D'Arcy J.M. Cain <darcy@druid.net>         |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 788 2246     (DoD#0082)    (eNTP)   |  what's for dinner.
IM: darcy@Vex.Net, VOIP: sip:darcy@Vex.Net


pgsql-general by date:

Previous
From: "D'Arcy J.M. Cain"
Date:
Subject: Re: Money casting too liberal?
Next
From: "D'Arcy J.M. Cain"
Date:
Subject: Re: Money casting too liberal?