From: | Дмитрий Иванов <firstdismay(at)gmail(dot)com> |
---|---|
To: | Ron <ronljohnsonjr(at)gmail(dot)com> |
Cc: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: insert column monetary type ver 2 |
Date: | 2021-11-21 04:44:14 |
Message-ID: | CAPL5KHpTLkYkMOvK0i4+aYe8_j617=VdKMG0Q5XXUSepvDcx0A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I think I would love to discuss this topic, but my English won't allow it.
I understand this type is there but the best way to avoid mistakes when
working with it is not to work with it. thank you.
вс, 21 нояб. 2021 г. в 09:02, Ron <ronljohnsonjr(at)gmail(dot)com>:
> On 11/20/21 11:01 AM, Tom Lane wrote:
> > =?UTF-8?B?0JTQvNC40YLRgNC40Lkg0JjQstCw0L3QvtCy?= <firstdismay(at)gmail(dot)com>
> writes:
> >> I can't figure out the problem. Digit group group separator causes an
> >> insertion error, what should I do?
> >> lc_monetary = 'ru_RU.UTF-8'
> > On my RHEL8 (moderately recent glibc) platform, that locale's
> > mon_thousands_sep symbol is not a plain space but "\342\200\257":
> >
> > p *lconvert
> > $3 = {decimal_point = 0x23ef120 ".", thousands_sep = 0x23ef140 "",
> > grouping = 0x23ef160 "", int_curr_symbol = 0x23ef1a0 "RUB ",
> > currency_symbol = 0x23ef1c0 "\342\202\275",
> > mon_decimal_point = 0x23ef1e0 ",",
> > mon_thousands_sep = 0x23ef200 "\342\200\257",
> > mon_grouping = 0x23ef220 "\003\003", positive_sign = 0x23ef240 "",
> > negative_sign = 0x23ef260 "-", int_frac_digits = 2 '\002',
> > frac_digits = 2 '\002', p_cs_precedes = 0 '\000', p_sep_by_space = 1
> '\001',
> > n_cs_precedes = 0 '\000', n_sep_by_space = 1 '\001', p_sign_posn = 1
> '\001',
> > n_sign_posn = 1 '\001', int_p_cs_precedes = 0 '\000',
> > int_p_sep_by_space = 0 '\000', int_n_cs_precedes = 0 '\000',
> > int_n_sep_by_space = 0 '\000', int_p_sign_posn = 0 '\000',
> > int_n_sign_posn = 0 '\000'}
> >
> > 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".
>
> --
> Angular momentum makes the world go 'round.
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2021-11-21 05:31:38 | Re: pg_dump insert column GENERATED |
Previous Message | Дмитрий Иванов | 2021-11-21 04:39:01 | Re: pg_dump insert column GENERATED |