Alvaro Herrera <alvherre@atentus.com> writes:
> alvh=> CREATE TABLE money_test (a money);
> CREATE TABLE
> alvh=> INSERT INTO money_test VALUES (2);
> ERROR: column "a" is of type 'money' but expression is of type 'integer'
> You will need to rewrite or cast the expression
> alvh=> INSERT INTO money_test VALUES ('2');
> ERROR: Bad money external representation 2
> alvh=> INSERT INTO money_test VALUES ('2.00');
> ERROR: Bad money external representation 2.00
> alvh=> INSERT INTO money_test VALUES ('$2.00');
> ERROR: Bad money external representation $2.00
> alvh=> INSERT INTO money_test VALUES ('2'::money);
> ERROR: Bad money external representation 2
What does "show lc_monetary" say? I think you may be in a non-US locale.
regards, tom lane
