Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2])
	by hub.org (8.9.3/8.9.3) with ESMTP id NAA50513
	for <pgsql-interfaces@postgreSQL.org>;
	Sun, 30 Jan 2000 13:09:54 -0500 (EST)
	(envelope-from tgl@sss.pgh.pa.us)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id NAA27640;
	Sun, 30 Jan 2000 13:09:30 -0500 (EST)
To: Byron Nikolaidis <byron.nikolaidis@home.com>
cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Max Precision/Scale of Postgres Numeric Type? 
In-reply-to: <3894790D.3B0D324@home.com> 
References: <3894790D.3B0D324@home.com>
Comments: In-reply-to Byron Nikolaidis <byron.nikolaidis@home.com>
	message dated "Sun, 30 Jan 2000 12:46:53 -0500"
Date: Sun, 30 Jan 2000 13:09:29 -0500
Message-ID: <27637.949255769@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

Byron Nikolaidis <byron.nikolaidis@home.com> writes:
> 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?

1000, according to src/include/utils/numeric.h.  (You could make it
even bigger by editing that file...)

			regards, tom lane