Re: insert column monetary type ver 2 - Mailing list pgsql-general

From Adrian Klaver
Subject Re: insert column monetary type ver 2
Date
Msg-id 2b715bbd-02f9-a8b1-7f50-a41ab51efcbf@aklaver.com
Whole thread Raw
In response to Re: insert column monetary type ver 2  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: insert column monetary type ver 2  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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.klaver@aklaver.com



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: pg_dump insert column GENERATED
Next
From: Дмитрий Иванов
Date:
Subject: Re: pg_dump insert column GENERATED