On Fri, Jun 18, 2004 at 11:42:29 -0400,
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> The SQL spec doesn't allow unconstrained lengths for these types
> so it gives no guidance about what to display in the information_schema
> views. Any opinions?
It might make some sense to use the maximum length supported by the type
for the precision. The documentations says that numeric is limited to
1000 digits.
If there isn't a set scale for the type, then NULL would probably make the
most sense.