On Fri, Jun 18, 2004 at 11:42:29 -0400, Tom Lane <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster