Re: New version of money type

From: AgentM <agentm(at)themactionfaction(dot)com>
To: postgres hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: New version of money type
Date: 2006-09-14 18:12:30
Message-ID: 5AB8FBEF-90A4-4E04-A1A8-1E001938DD0E@themactionfaction.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


On Sep 14, 2006, at 14:04 , D'Arcy J.M. Cain wrote:

> On Thu, 14 Sep 2006 10:33:19 -0700
> "Joshua D. Drake" <jd(at)commandprompt(dot)com> wrote:
>>> By the way, I removed the currency symbol from the output. Would
>>> removing the commas also make sense? These are the sorts of things
>>> that can be added by applications.
>>
>> I don't think that we should be providing *any* presentation
>> beyond the
>> actual representation of the data. What if it is not US dollars? :)
>
> That's what locale is for. It looks at that to determine that sort of
> stuff including currency symbol before I removed it.

If you force the locale into the money type, then the entire column
must be of the same currency. That seems like an unnecessary
limitation. Does your type support banker's rounding?

-M

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Wong 2006-09-14 18:13:33 Re: Lock partitions
Previous Message Bruce Momjian 2006-09-14 18:10:41 Re: contrib/xml2 and PG_MODULE_MAGIC