Tom Lane wrote:
> "Dave Page" <dpage@vale-housing.co.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?
>
I get the following from 8.2beta1 - looks like it doesn't like the
double quotes.
postgres=# select '123.45'::money; money
--------- $123.45
(1 row)
postgres=# select '$123.45'::money; money
--------- $123.45
(1 row)
postgres=# select "123.45"::money;
ERROR: column "123.45" does not exist
LINE 1: select "123.45"::money; ^
postgres=# select "$123.45"::money;
ERROR: column "$123.45" does not exist
LINE 1: select "$123.45"::money; ^