Received: from bjke.com (firewall-user@ganymede.bjke.com [144.210.8.38])
	by hub.org (8.9.1/8.9.1) with ESMTP id OAA04949
	for <pgsql-interfaces@postgreSQL.org>;
	Wed, 11 Nov 1998 14:01:22 -0500 (EST)
	(envelope-from djackson@cpsgroup.com)
Received: by bjke.com; id NAA19430; Wed, 11 Nov 1998 13:01:19 -0600 (CST)
Received: from cpsmail.cpsgroup.com(144.210.12.11) by gauntlet.bjke.com via
	smap (4.1) id xmaa18745; Wed, 11 Nov 98 13:00:41 -0600
Received: by cpsmail with Internet Mail Service (5.0.1458.49)
	id <WCM4D95G>; Wed, 11 Nov 1998 13:03:15 -0600
Message-ID: <F10BB1FAF801D111829B0060971D839F4F2EC0@cpsmail>
From: "Jackson, DeJuan" <djackson@cpsgroup.com>
To: "Ken J. Wright" <ken@ori-ind.com>, pgsql-interfaces@postgreSQL.org
Subject: RE: [INTERFACES] money format
Date: Wed, 11 Nov 1998 13:03:15 -0600
X-Priority: 3
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.0.1458.49)
Content-Type: text/plain

> 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
> 
Don't what version you are using but using '100.23' works for me.
	-DEJ