Re: About the MONEY type - Mailing list pgsql-general

From btober@computer.org
Subject Re: About the MONEY type
Date
Msg-id 1487702900.95322553.1480533830677.JavaMail.zimbra@broadstripe.net
Whole thread Raw
In response to Re: About the MONEY type  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: About the MONEY type  (John McKown <john.archie.mckown@gmail.com>)
List pgsql-general

----- Original Message -----
> From: "Merlin Moncure" <mmoncure@gmail.com>
> To: "Raymond O'Donnell" <rod@iol.ie>
> Cc: "Thomas Kellerer" <spam_eater@gmx.net>, "PostgreSQL General" <pgsql-general@postgresql.org>
> Sent: Wednesday, November 30, 2016 11:41:39 AM
> Subject: Re: [GENERAL] About the MONEY type
>
> On Wed, Nov 30, 2016 at 7:43 AM, Raymond O'Donnell <rod@iol.ie> wrote:
> > On 30/11/16 12:05, Thomas Kellerer wrote:
> >>
> >> Tobia Conforto schrieb am 30.11.2016 um 12:15:
> >>>
> >>> I think MONEY is a great datatype, at least in theory.
> >>
> >>
> >> I personally find it pretty useless to be honest - especially because
> >> the currency symbol depends on the client.
> >>
> >> ...
> >
> >
> > I seem to remember that it was actually deprecated at some point - this is
> > going back quite a few years. This was later reversed, though I don't know
> > why.
>
> It was moved from a 32 bit implementation to a 64 bit one, and it was
> given a lot of the previously missing basic infrastructure ...

I recall a number of years ago reading about a money implementation that included different currency bases and exchange
ratecalculation. 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



pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: select function alias
Next
From: Patrick B
Date:
Subject: Re: Monitoring Replication - Postgres 9.2