Re: Casting to money

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;               ^