Re: [BUGS] BUG #14894: Data Type Money - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: [BUGS] BUG #14894: Data Type Money
Date
Msg-id CAKFQuwbL5y2dsoFCR86zBnFrB_tDU=5k3ETEspqC8VfB_RynvQ@mail.gmail.com
Whole thread Raw
In response to Re: [BUGS] BUG #14894: Data Type Money  (John R Pierce <pierce@hogranch.com>)
List pgsql-bugs
On Thursday, November 9, 2017, John R Pierce <pierce@hogranch.com> wrote:
use NUMERIC(19,4)...    the MONEY type really should be deprecated


I find it has strong, if limited, usefulness when input data is a currency string and you want to directly parse it into a table as an amount and not text which you then have to post-process.  If your input is already a pure number then numeric is a far better choice.

David J.

pgsql-bugs by date:

Previous
From: John R Pierce
Date:
Subject: Re: [BUGS] BUG #14894: Data Type Money
Next
From: Michael Paquier
Date:
Subject: Re: [BUGS] BUG #14866: The generated constraint in the typed tablecauses the server to crash