If you need to be able to cast money to numeric, you can just write your
own cast. This is one of the things about postgres that I dearly love.
You could probably even write the cast function in SQL using regular
expressions.
Then, you just write a query with an explicit cast, e.g. SELECT foo ::
numeric FROM bar;
I noticed in the docs that the money type is actually deprecated, so you
probably want to consider converting your column to the numeric type
regardless.
BJ
Jerry wrote:
>Is it possible to turn off the "$" and "," that appear in "money" formatted
>columns so I can dump the table in a numeric format?
>
>The man page hints that lc_monetary controls the formatting but I
>cannot find any clues on what to do...
>
>Apparently money cannot be cast to anything.
>
>I don't think it will be hard to write a custom tcl/perl
>script that takes a "copy checks to...." command to do the task
>but I would like a cleaner solution....
>
>
>Jerry
>
>---------------------------(end of broadcast)---------------------------
>TIP 8: explain analyze is your friend
>
>
