insert column monetary type ver 2

On Sunday, November 21, 2021, Ron <ronljohnsonjr(at)gmail(dot)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(at)gmail(dot)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.