Re: insert column monetary type ver 2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: Ron <ronljohnsonjr(at)gmail(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: insert column monetary type ver 2
Date: 2021-11-22 16:47:44
Message-ID: 3756995.1637599664@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message AC Gomez 2021-11-22 22:21:12
Previous Message Дмитрий Иванов 2021-11-22 16:42:55 Re: pg_dump insert column GENERATED