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

From David G. Johnston
Subject insert column monetary type ver 2
Date
Msg-id CAKFQuwaoNoeU0m9FSZNm2ag7eBMA+p8QD8O7CNvAR0i-uTH4kQ@mail.gmail.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  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general
On Sunday, November 21, 2021, Ron <ronljohnsonjr@gmail.com> wrote:
On 11/21/21 7:33 PM, Adrian Klaver wrote:
On 11/21/21 17:08, Ron wrote:
On 11/21/21 10:27 AM, Tom Lane wrote:
Ron <ronljohnsonjr@gmail.com> writes:

The contrary argument is that people tend not to like "best guess"
behavior when working with monetary amounts.

Best Guess is relative.  Breaking because of "ASCII Space" instead of "narrow no-break space" is definitely Not Right.

The people I have worked for have forgiven me many sins, messing up the money is not one of them.

Not inserting this record is also messing up the money.


Adding processing smarts here is Not Definitely Right.  And the status quo is Not Definitely Wrong.  As long as we don’t have a round-trip problem I’d lean toward maintaining the status quo and accept the complaints that we aren’t being as flexible as we could be with our money type.  That we interpret the LC setting exactly is a defensible position to take.  Especially since money is a type we advise people avoid anyway.  We can just add this to the list of reasons why.

David J.

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: insert column monetary type ver 2
Next
From: Ron
Date:
Subject: Re: insert column monetary type ver 2