Re: insert column monetary type ver 2
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: Ron <ronljohnsonjr@gmail.com>,
"pgsql-general@lists.postgresql.org"
<pgsql-general@lists.postgresql.org>
Date: 2021-11-22T16:47:44Z
Lists: pgsql-general
Adrian Klaver <adrian.klaver@aklaver.com> writes: > On 11/21/21 19:21, Ron wrote: >> Why then does the money type exist? At the very least, why isn't it >> deprecated? > It was at one point: > https://www.postgresql.org/docs/8.2/datatype-money.html > Not entirely sure why it was revived. You can search the mailing list > archive for discussions on this. I think we concluded there was no appetite for actually removing it. 8.3 fixed the very worst problem that had led to deprecation, namely making it an 8-byte integer not 4-byte, so we concluded that it had at least some excuse to live. As already noted, if it doesn't do what you want, don't use it. regards, tom lane