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
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]) |