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
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 |