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;
^
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
