Re: 7.4's INFORMATION_SCHEMA.Columns View

Поиск
Список
Период
Сортировка
От mike.griffin@mygenerationsoftware.com
Тема Re: 7.4's INFORMATION_SCHEMA.Columns View
Дата
Msg-id 4585.4.160.153.201.1087607483.squirrel@4.160.153.201
обсуждение исходный текст
Ответ на Re: 7.4's INFORMATION_SCHEMA.Columns View  (Bruno Wolff III <bruno@wolff.to>)
Ответы Re: 7.4's INFORMATION_SCHEMA.Columns View  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: mike.griffin@mygenerationsoftware.com
Дата:
Сообщение: Re: 7.4's INFORMATION_SCHEMA.Columns View
Следующее
От: Tom Lane
Дата:
Сообщение: Re: 7.4's INFORMATION_SCHEMA.Columns View