Horton

Re: monetary bug

Hannu Krosing <hannu@tm.ee>

View thread
From: Hannu Krosing <hannu@tm.ee>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Peter Eisentraut <peter_e@gmx.net>, Mike Mascari <mascarm@mascari.com>, Mahmoud Taghizadeh <m_taghi@yahoo.com>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2004-08-22T21:56:27Z
Lists: pgsql-hackers 
On P, 2004-08-22 at 23:07, Tom Lane wrote:
> Peter Eisentraut <peter_e@gmx.net> writes:
> > Tom Lane wrote:
> >> We keep hoping someone will step up to the plate and rewrite it,
> >> instead. Per previous discussion, the type really ought to be a thin
> >> layer over "numeric", with most likely no operations of its own
> >> except I/O conversion.
> 
> > And what would it do with it?  Add a currency symbol?  Which one?  Which 
> > form?  Where?  Format the numbers some way?
> 
> The idea behind the money type is to format per the lc_monetary locale
> setting, which seems perfectly reasonable to me.

so if you put in $1.00 using en_US.UTF8 then another user using en_CA
would get 1.00CAD and I would get 1.00 EEK ?

It does make /some/ sense - I would be all for that if this is the sum I
mus pay, but object strongly if the sum must be paid *to* me ;)

--------------
Hannu