Thread: remove $ from money field

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

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

money as a datatype is deprecated, use numeric(9,2) instead (or whatever
precision you need).

Datatypes:
http://developer.postgresql.org/docs/postgres/datatype-money.html
http://developer.postgresql.org/docs/postgres/datatype.html#DATATYPE-NUMERIC-DECIMAL

Formatting:
http://developer.postgresql.org/docs/postgres/functions-formatting.html

Robby Russell <rrussell@commandprompt.com> writes:
> When selecting a field that is of type money, how can I remove the $
> when selected?

Actually, almost the only thing money does for you is put in the $ sign
;-).  I'd recommend using type numeric instead, if you have any desire
for more flexibility.

            regards, tom lane

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