"Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> writes:
> select '$123.45'::money
> ERROR: invalid input syntax for type money: "$123.45"
> select '123.00'::money
> ERROR: invalid input syntax for type money: "123.00"
So ... what locale are you trying this in?
regards, tom lane