pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedMax Precision/Scale of Postgres Numeric Type?
2+ messages / 2 participants
[nested] [flat]
* Max Precision/Scale of Postgres Numeric Type?
@ 2000-01-30 17:46 Byron Nikolaidis <byron.nikolaidis@home.com>
0 siblings, 1 reply; 2+ messages in thread
From: Byron Nikolaidis @ 2000-01-30 17:46 UTC (permalink / raw)
To: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [INTERFACES] Max Precision/Scale of Postgres Numeric Type?
@ 2000-01-30 18:09 Tom Lane <tgl@sss.pgh.pa.us>
parent: Byron Nikolaidis <byron.nikolaidis@home.com>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2000-01-30 18:09 UTC (permalink / raw)
To: Byron Nikolaidis <byron.nikolaidis@home.com>; +Cc: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2000-01-30 18:09 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-01-30 17:46 Max Precision/Scale of Postgres Numeric Type? Byron Nikolaidis <byron.nikolaidis@home.com>
2000-01-30 18:09 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox