| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | John R Pierce <pierce(at)hogranch(dot)com> |
| Cc: | "tfredy02(at)gmail(dot)com" <tfredy02(at)gmail(dot)com>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: BUG #14894: Data Type Money |
| Date: | 2017-11-09 23:06:04 |
| Message-ID: | CAKFQuwbL5y2dsoFCR86zBnFrB_tDU=5k3ETEspqC8VfB_RynvQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Thursday, November 9, 2017, John R Pierce <pierce(at)hogranch(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2017-11-10 02:33:05 | Re: BUG #14866: The generated constraint in the typed table causes the server to crash |
| Previous Message | John R Pierce | 2017-11-09 22:21:02 | Re: BUG #14894: Data Type Money |