| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | 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:19:32 |
| Message-ID: | 2b715bbd-02f9-a8b1-7f50-a41ab51efcbf@aklaver.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 11/21/21 19:21, Ron wrote:
>
>
>
> Which means *that* is broken.
>
>> Especially since money is a type we advise people avoid anyway. We
>> can just add this to the list of reasons why.
>
> 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.
Bottom line is if you don't want surprises use numeric and format the
output on the client side.
>
> --
> Angular momentum makes the world go 'round.
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Дмитрий Иванов | 2021-11-22 16:42:55 | Re: pg_dump insert column GENERATED |
| Previous Message | Adrian Klaver | 2021-11-22 16:11:51 | Re: pg_dump insert column GENERATED |