| 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: | Whole Thread | Raw Message | 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
| 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 |