Re: 7.4's INFORMATION_SCHEMA.Columns View - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: 7.4's INFORMATION_SCHEMA.Columns View
Date
Msg-id 20040618161525.GA10695@wolff.to
Whole thread Raw
In response to Re: 7.4's INFORMATION_SCHEMA.Columns View  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: 7.4's INFORMATION_SCHEMA.Columns View  (mike.griffin@mygenerationsoftware.com)
List pgsql-general
On Fri, Jun 18, 2004 at 11:42:29 -0400,
  Tom Lane <tgl@sss.pgh.pa.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.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: 7.4's INFORMATION_SCHEMA.Columns View
Next
From: Tom Lane
Date:
Subject: Re: putting binary data in a char field?