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

From Ron
Subject Re: insert column monetary type ver 2
Date
Msg-id 74183538-0a51-9580-87a8-8b33274c9159@gmail.com
Whole thread Raw
In response to Re: insert column monetary type ver 2  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: insert column monetary type ver 2  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
On 11/21/21 10:27 AM, Tom Lane wrote:
> Ron <ronljohnsonjr@gmail.com> writes:
>> On 11/20/21 11:01 AM, Tom Lane wrote:
>>> A quick lookup later, that's U+202F or "narrow no-break space".
>>> cash_in is picky about this, and won't take plain ASCII space as
>>> a substitute.  Not sure if it should.
>> It probably should, based on the Robustness Principle: "be conservative in
>> what you send, be liberal in what you accept".
> 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.

-- 
Angular momentum makes the world go 'round.



pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Error when rewriting a query into multiple queries
Next
From: Adrian Klaver
Date:
Subject: Re: insert column monetary type ver 2