Re: About the MONEY type

From: "btober(at)computer(dot)org" <btober(at)broadstripe(dot)net>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: Raymond O'Donnell <rod(at)iol(dot)ie>, Thomas Kellerer <spam_eater(at)gmx(dot)net>, PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: About the MONEY type
Date: 2016-11-30 19:23:50
Message-ID: 1487702900.95322553.1480533830677.JavaMail.zimbra@broadstripe.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

----- Original Message -----
> From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
> To: "Raymond O'Donnell" <rod(at)iol(dot)ie>
> Cc: "Thomas Kellerer" <spam_eater(at)gmx(dot)net>, "PostgreSQL General" <pgsql-general(at)postgresql(dot)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(at)iol(dot)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 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Patrick B 2016-11-30 19:57:45 Re: Monitoring Replication - Postgres 9.2
Previous Message Merlin Moncure 2016-11-30 19:21:21 Re: select function alias