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

From mike.griffin@mygenerationsoftware.com
Subject Re: 7.4's INFORMATION_SCHEMA.Columns View
Date
Msg-id 4585.4.160.153.201.1087607483.squirrel@4.160.153.201
Whole thread Raw
In response to Re: 7.4's INFORMATION_SCHEMA.Columns View  (Bruno Wolff III <bruno@wolff.to>)
Responses Re: 7.4's INFORMATION_SCHEMA.Columns View  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Ah yes, is that in pg_types, good idea, I might override that after I make
the query.

> 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: mike.griffin@mygenerationsoftware.com
Date:
Subject: Re: 7.4's INFORMATION_SCHEMA.Columns View
Next
From: Tom Lane
Date:
Subject: Re: 7.4's INFORMATION_SCHEMA.Columns View