money format

From: "Ken J(dot) Wright" <ken(at)ori-ind(dot)com>
To: pgsql-interfaces(at)postgreSQL(dot)org
Subject: money format
Date: 1998-11-11 18:09:42
Message-ID: 3.0.1.32.19981111100942.00861880@ori-ind.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-interfaces by date

  From Date Subject
Next Message Jackson, DeJuan 1998-11-11 19:03:15 RE: [INTERFACES] money format
Previous Message Cary B. O'Brien 1998-11-11 17:21:09 ODBC interface problem W/ Applix Data (was Re: AWL: Another Data Editing Problem [was Re: Editing problem in Data])