Received: from mail2.rdc2.ab.home.com (mail2.rdc2.ab.home.com [24.64.2.49])
	by postgresql.org (8.11.3/8.11.1) with ESMTP id f4BMIlA62662
	for <pgsql-interfaces@postgresql.org>;
	Fri, 11 May 2001 18:18:47 -0400 (EDT)
	(envelope-from wsmuir@islandnet.com)
Received: from fozzy ([24.67.94.220]) by mail2.rdc2.ab.home.com
	(InterMail vM.4.01.03.20 201-229-121-120-20010223) with SMTP
	id <20010511221842.YERA18658.mail2.rdc2.ab.home.com@fozzy>
	for <pgsql-interfaces@postgresql.org>;
	Fri, 11 May 2001 15:18:42 -0700
From: "Scott Muir" <wsmuir@islandnet.com>
To: <pgsql-interfaces@postgresql.org>
Subject: JDBC and numeric datatype...
Date: Fri, 11 May 2001 16:16:35 -0600
Message-ID: <NCBBKLMCJOGCLFHOFECNKENIDMAA.wsmuir@islandnet.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0)
Importance: Normal
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
X-Archive-Number: 200105/57
X-Sequence-Number: 1584

Can someone suggest the correct way of dealing with the NUMERIC data type
through JDBC?  The attribute in question is a NUMERIC(10,2) (currency)...
We're thinking of just using a float to handle it...  Since this type can be
much larger than we're using, what should be used in those cases???

Thanks.
S.