Search Postgresql Archives

Re: About the MONEY type

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, Nov 30, 2016 at 1:23 PM, btober@xxxxxxxxxxxx <btober@xxxxxxxxxxxxxxx> wrote:

I recall a number of years ago reading about a money implementation that included different currency bases and exchange rate calculation. A quick Google search turned up


https://github.com/samv/pg-currency


which I am not sure is the same thing, but it looks like it might be something useful in the current context.

-- B

Speaking generically, ​I guess maybe MONEY needs to be somewhat like a TIMESTAMP. At least in PostgreSQL​, a TIMESTAMP can contain a TIMEZONE. I guess a MONEY type should contain a modifier identifying the issuer of the currency (E.g. U.S. Dollar vs Canadian Dollar vs. Yen vs. Yuan vs. "precious metal").


--
Heisenberg may have been here.


Maranatha! <><
John McKown

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux