Received: from orion3.ori-ind.com (IDENT:root@[206.81.197.190]) by hub.org (8.9.1/8.9.1) with ESMTP id NAA24260 for ; Wed, 11 Nov 1998 13:06:53 -0500 (EST) (envelope-from ken@ori-ind.com) Received: from Ken.ori-ind.com (avanti.ori-ind.com [192.168.61.99]) by orion3.ori-ind.com (8.8.7/8.8.4) with SMTP id KAA02684 for ; Wed, 11 Nov 1998 10:13:38 GMT Message-Id: <3.0.1.32.19981111100942.00861880@ori-ind.com> X-Sender: ken@ori-ind.com X-Mailer: Windows Eudora Pro Version 3.0.1 (32) Date: Wed, 11 Nov 1998 10:09:42 -0800 To: pgsql-interfaces@postgreSQL.org From: "Ken J. Wright" Subject: money format Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" 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