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 |
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").
Maranatha! <><
John McKown
John McKown
В списке pgsql-general по дате отправления: