Re: [GENERAL] About the MONEY type - Mailing list pgsql-general

From Rob Sargent
Subject Re: [GENERAL] About the MONEY type
Date
Msg-id BF08F246-2D0C-4FE2-91A3-8A6683190299@gmail.com
Whole thread Raw
In response to Re: [GENERAL] About the MONEY type  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
Responses Re: [GENERAL] About the MONEY type
List pgsql-general
> 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] Concatenating NULL with JSONB value return NULL
Next
From: Jong-won Choi
Date:
Subject: Re: [GENERAL] Concatenating NULL with JSONB value return NULL