Re: Suggested (or existing) way to parse currency into numeric?

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Suggested (or existing) way to parse currency into numeric?
Дата
Msg-id CAKFQuwYQMU6OZxn04V_n3+qHq6ofxNhSiqv09YUPJo6i51t5gA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Suggested (or existing) way to parse currency into numeric?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Дерево обсуждения

​I wrote that type off as something I would never code into my own
schema so basically forgot about its usability in other situations.

Though if you do not want to use the money type in a table you could do:

test=> select '$18,665'::money::numeric;
 numeric
----------
 18665.00
(1 row)


​Except I have to define the table with money so that json_populate_record uses the correct cast.  But yes, when actually using the data, or if I decide to make a view on top of the table, I can cast from money to numeric.

I guess I could define a custom type using money and then define the table using numeric and transform in between; but its yet another definition to keep in sync.

Money perfectly meets my current need and no longer has my scorn.

David J.
​
 

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Suggested (or existing) way to parse currency into numeric?
Следующее
От: Francisco Olarte
Дата:
Сообщение: Re: double precision[] storage space questions