Re: Extracting data from deprecated MONEY fields

From: Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>
To: Ken Winter <ken(at)sunward(dot)org>
Cc: 'PostgreSQL pg-general List' <pgsql-general(at)postgresql(dot)org>
Subject: Re: Extracting data from deprecated MONEY fields
Date: 2008-06-07 19:51:47
Message-ID: 484AE6D3.90103@zigo.dhs.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Here is a cast function I wrote some years ago to convert a couple of
money columns to numeric

http://zigo.org/postgresql/#cast_money_to_numeric

You already have a solution, but maybe it is of value to someone else.

/Dennis

Ken Winter skrev:
> Right you are, Tom!
>
> In case anyone else is facing the same migration, pasted in below is a
> pl/pgsql function that does the conversion.
>
> ~ Thanks to all
> ~ Ken
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Viktor Rosenfeld 2008-06-07 23:16:56 Re: temporarily deactivate an index
Previous Message Ken Winter 2008-06-07 19:27:27 Re: Extracting data from deprecated MONEY fields