Postgres Pro
Downloads
Home   >   mailing lists

Max Precision/Scale of Postgres Numeric Type? - Mailing list pgsql-interfaces

From Byron Nikolaidis
Subject Max Precision/Scale of Postgres Numeric Type?
Date
Msg-id 3894790D.3B0D324@home.com
Whole thread Raw
Responses Re: [INTERFACES] Max Precision/Scale of Postgres Numeric Type?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-interfaces
Tree view 
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

pgsql-interfaces by date:

Previous
From: Frank Joerdens
Date:
Subject: ODBC and BLOBs
Next
From: Tom Lane
Date:
Subject: Re: [INTERFACES] Max Precision/Scale of Postgres Numeric Type?