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 $workabl
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
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
