Re: insert column monetary type ver 2

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: insert column monetary type ver 2
Date: 2021-11-22 01:08:59
Message-ID: 74183538-0a51-9580-87a8-8b33274c9159@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 11/21/21 10:27 AM, Tom Lane wrote:
> Ron <ronljohnsonjr(at)gmail(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2021-11-22 01:33:58 Re: insert column monetary type ver 2
Previous Message David G. Johnston 2021-11-21 17:59:11 Re: Error when rewriting a query into multiple queries