money format - Mailing list pgsql-interfaces

From Ken J. Wright
Subject money format
Date
Msg-id 3.0.1.32.19981111100942.00861880@ori-ind.com
Whole thread Raw
List pgsql-interfaces
insert into table values (100);
insert into table values (100.);
insert into table values (100.00);

Error while executing the query;
WARN:Bad money external representation
100.000000 (1)

I've searched the docs, but I can not find how to enter a value in a money
field. It would seem that any number should sqeeze in, even with forced
rounding by the backend. It shouldn't be this hard ;-(

Tried with psql, libpq, BDD.

Ken

pgsql-interfaces by date:

Previous
From: "Cary B. O'Brien"
Date:
Subject: ODBC interface problem W/ Applix Data (was Re: AWL: Another Data Editing Problem [was Re: Editing problem in Data])
Next
From: "Jackson, DeJuan"
Date:
Subject: RE: [INTERFACES] money format