Re: Precision of calculated numeric fields - Mailing list pgsql-general

From Tom Lane
Subject Re: Precision of calculated numeric fields
Date
Msg-id 961.960326406@sss.pgh.pa.us
Whole thread Raw
In response to Re: Precision of calculated numeric fields  (Travis Bauer <trbauer@indiana.edu>)
List pgsql-general
Travis Bauer <trbauer@indiana.edu> writes:
> Is this the mod field of the Field class in JDBC2?

Sounds right, but I haven't looked at the JDBC code.

> Does -1 alway mean, for
> numeric types, that the precision is undefined?

Right.  In general, -1 is the default typmod if Postgres doesn't have
any better idea what to put in.  So type-specific code always has to
be prepared to do something reasonable with that typmod value ...

            regards, tom lane

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: getting inet out of char?
Next
From: Tom Lane
Date:
Subject: Re: Vacuum Question