Received: from mail.rdc1.md.home.com (imail@ha2.rdc1.md.home.com [24.2.2.67])
	by hub.org (8.9.3/8.9.3) with ESMTP id MAA36408
	for <pgsql-interfaces@postgreSQL.org>;
	Sun, 30 Jan 2000 12:47:04 -0500 (EST)
	(envelope-from byron.nikolaidis@home.com)
Received: from home.com ([24.4.141.52]) by mail.rdc1.md.home.com
	(InterMail v4.01.01.00 201-229-111) with ESMTP
	id <20000130174703.HPXT7935.mail.rdc1.md.home.com@home.com>
	for <pgsql-interfaces@postgreSQL.org>;
	Sun, 30 Jan 2000 09:47:03 -0800
Message-ID: <3894790D.3B0D324@home.com>
Date: Sun, 30 Jan 2000 12:46:53 -0500
From: Byron Nikolaidis <byron.nikolaidis@home.com>
Organization: @Home Network
X-Mailer: Mozilla 4.5 [en]C-AtHome0405  (Win95; U)
X-Accept-Language: en
MIME-Version: 1.0
To: pgsql-interfaces@postgreSQL.org
Subject: Max Precision/Scale of Postgres Numeric Type?
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


Hi all,

I'm implementing the Postgres Numeric Type in the odbc driver, and was
wondering what the maximum precision and scale for the postgres
"numeric" type is?  It seems pretty huge -- I tried numeric(150, 100 )
with no problem!

Note, this is not the precision/scale returned in the atttypmod field
which I use for SQLColumns and SQLDescribeCol/SQLColAttributes, but for
the SQLGetTypeInfo odbc function, which needs maximums for the data type
itself.

Thanks,

Byron