Re: About the MONEY type

Поиск
Список
Период
Сортировка
От John McKown
Тема Re: About the MONEY type
Дата
Msg-id CAAJSdjgC1fsoOmY1p2jVk2T_=hRv8d5bH1TXigjWvNvqLBX3xw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: About the MONEY type  ("btober@computer.org" <btober@broadstripe.net>)
Ответы Re: About the MONEY type
Re: About the MONEY type
Список pgsql-general
On Wed, Nov 30, 2016 at 1:23 PM, btober@computer.org <btober@broadstripe.net> 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

В списке pgsql-general по дате отправления:

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: How to migrate from PGSQL 9.3 to 9.6
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: About the MONEY type