Re: [GENERAL] About the MONEY type
От | Gavin Flower |
---|---|
Тема | Re: [GENERAL] About the MONEY type |
Дата | |
Msg-id | 9a57a26d-cf9a-90bc-34e2-a9a0f5e4dc14@archidevsys.co.nz обсуждение исходный текст |
Ответ на | Re: [GENERAL] About the MONEY type (Rob Sargent <robjsargent@gmail.com>) |
Список | pgsql-general |
On 19/12/16 14:17, Rob Sargent wrote: >> On Dec 18, 2016, at 5:23 PM, Gavin Flower <GavinFlower@archidevsys.co.nz> wrote: >> >> On 18/12/16 12:25, Bruce Momjian wrote: >>> On Wed, Nov 30, 2016 at 01:35:12PM -0800, John R Pierce wrote: >>>> note, btw, TIMESTAMP WITH TIME ZONE doesn't actually store the timezone... >>>> rather, it converts it to an internal representation of GMT, and then converts >>>> it back to display time at the client's current (or specified) time zone. >>> Right, TIMESTAMP WITH TIME ZONE converts the timestamp value to the >>> local time zone on output. Imagine a monetary type that converted the >>> money amount to local currency on output --- that would be cool. >>> >> Hmm... >> >> Would need to know the appropriate conversion rate. the 2 obvious dates/times, on entry and now, may neither be the onewanted. >> >> Also, often the buy/sell conversion rates are not the same! >> >> Am sure there also other issues. >> >> I don't think automatic conversion is as easy as you make it out to be. >> >> >> >> Cheers, >> >> Gavin >> > Bets on how serious Mr. Pierce was are currently trending in Vegas. > :-)
В списке pgsql-general по дате отправления: