----- Original Message ----- > From: "Merlin Moncure" <mmoncure@xxxxxxxxx> > To: "Raymond O'Donnell" <rod@xxxxxx> > Cc: "Thomas Kellerer" <spam_eater@xxxxxxx>, "PostgreSQL General" <pgsql-general@xxxxxxxxxxxxxx> > Sent: Wednesday, November 30, 2016 11:41:39 AM > Subject: Re: About the MONEY type > > On Wed, Nov 30, 2016 at 7:43 AM, Raymond O'Donnell <rod@xxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
