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