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 по дате отправления:

Чтобы сделать работу с сайтом удобнее, мы используем cookie и аналитический сервис «Яндекс.Метрика». Продолжая пользоваться сайтом, вы соглашаетесь с их использованием.