insert column monetary type ver 2

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема insert column monetary type ver 2
Дата
Msg-id CAKFQuwaoNoeU0m9FSZNm2ag7eBMA+p8QD8O7CNvAR0i-uTH4kQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: insert column monetary type ver 2  (Ron <ronljohnsonjr@gmail.com>)
Ответы Re: insert column monetary type ver 2
Список 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 по дате отправления:

Предыдущее
От: Ron
Дата:
Сообщение: Re: insert column monetary type ver 2
Следующее
От: Ron
Дата:
Сообщение: Re: insert column monetary type ver 2