Skip site navigation (1) Skip section navigation (2)

Re: dividing money by money

From: Boszormenyi Zoltan <zb(at)cybertec(dot)at>
To: John R Pierce <pierce(at)hogranch(dot)com>
Cc: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, andy(at)balholm(dot)com,pgsql-bugs(at)postgresql(dot)org
Subject: Re: dividing money by money
Date: 2010-03-30 08:19:30
Message-ID: 4BB1B412.4030705@cybertec.at (view raw or flat)
Thread:
Lists: pgsql-bugs
John R Pierce írta:
> Boszormenyi Zoltan wrote:
>> Loading this dump into another database that happens
>> to have a different locale than hu_HU fails.
>>
>> But then any operator between two money values would
>> only work if both values have the same currency.
>>   
>
> indeed, its all a big tarpit.  next, you'll want currency conversion
> tables.  and, are there still any currenccies like old style UK where
> the subunits aren't 100ths?   schillings or whatever

Yeah, and we could also switch PG numeric type to base 12
to count in dozens or base 60 to deal with the mayan calendar...  ;-)

-- 
Bible has answers for everything. Proof:
"But let your communication be, Yea, yea; Nay, nay: for whatsoever is more
than these cometh of evil." (Matthew 5:37) - basics of digital technology.
"May your kingdom come" - superficial description of plate tectonics

----------------------------------
Zoltán Böszörményi
Cybertec Schönig & Schönig GmbH
http://www.postgresql.at/


In response to

pgsql-bugs by date

Next:From: Alvaro HerreraDate: 2010-03-30 13:49:32
Subject: Re: dividing money by money
Previous:From: John R PierceDate: 2010-03-30 08:13:05
Subject: Re: dividing money by money

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group