Re: About the MONEY type

On Wed, Nov 30, 2016 at 6:43 AM, Raymond O'Donnell <rod(at)iol(dot)ie> wrote:

>
> 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.
>
>
​Because its pointless to deprecate something that you haven't replaced and
have no intention of just removing without a replacement.

I use money as a column type for a very specific reason:

I have data that comes to me in a money-like format (one which money can
handle, though I'm in the U.S. so its limitations don't affect me as much)
within a JSON body and I can use the "json_to_record"​

​to directly populate a target table without having either pre-process the
value or store it as text and then perform post-processing. Once I have it
in as money ​a simple cast to numeric is reliable.

​Now, my GUI tool of choice chooses to simply return an empty string when
faced with data in money format but working within psql is solid.​

David J.