On Wed, Nov 30, 2016 at 6:43 AM, Raymond O'Donnell <r...@iol.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.
