Postgres Pro
Downloads
Home   >   mailing lists

Re: [INTERFACES] Max Precision/Scale of Postgres Numeric Type? - Mailing list pgsql-interfaces

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

pgsql-interfaces by date:

Previous
From: Byron Nikolaidis
Date:
Subject: Max Precision/Scale of Postgres Numeric Type?
Next
From: Byron Nikolaidis
Date:
Subject: NEW DRIVER v6.40.0008