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

>
>
>> ​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.
​