Re: remove $ from money field

As others have said, money is deprecated. I used this function to
migrate some money data once; you could use it to reformat data if you
wanted.

CREATE OR REPLACE FUNCTION x_money(money) RETURNS decimal AS '

    set moneydata $1

    regsub -all {[,$]} $moneydata {} workable

    return $workable

' language 'pltclu';


Robert Treat

On Fri, 2003-08-08 at 20:04, Robby Russell wrote:
> Should be a simple question.
>
> When selecting a field that is of type money, how can I remove the $
> when selected?
>
> example: $10.00 would return as 10.00
>
> -Robby
>
--
PostgreSQL :: The Enterprise Open Source Database