Re: New version of money type - Mailing list pgsql-hackers

From AgentM
Subject Re: New version of money type
Date
Msg-id 5AB8FBEF-90A4-4E04-A1A8-1E001938DD0E@themactionfaction.com
Whole thread Raw
In response to Re: New version of money type  ("D'Arcy J.M. Cain" <darcy@druid.net>)
Responses Re: New version of money type  ("D'Arcy J.M. Cain" <darcy@druid.net>)
List 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@commandprompt.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


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: contrib/xml2 and PG_MODULE_MAGIC
Next
From: Mark Wong
Date:
Subject: Re: Lock partitions