[GENERAL] Column information

Поиск
Список
Период
Сортировка
От Igor Korot
Тема [GENERAL] Column information
Дата
Msg-id CA+FnnTy-cyQwPZ3q0GJWJr=YKrZaEAQiikHXW1qafjrEJv23+g@mail.gmail.com
обсуждение исходный текст
Ответы Re: [GENERAL] Column information  (Alban Hertroys <haramrae@gmail.com>)
Re: [GENERAL] Column information  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Hi, ALL,
One more question if I may.

[code]
draft=# SELECT * FROM information_schema.columns WHERE table_name =
'leagues' AND ordinal_position = 8;
 table_catalog | table_schema | table_name | column_name  |
ordinal_position | column_default | is_nullable | data_type |
character_maximum_length | character_octet_length | numeric_precision
| numeric_precision_radix | numeric_scale | datetime_precision |
interval_type | interval_precision | character_set_catalog |
character_set_schema | character_set_name | collation_catalog |
collation_schema | collation_name | domain_catalog | domain_schema |
domain_name | udt_catalog | udt_schema | udt_name | scope_catalog |
scope_schema | scope_name | maximum_cardinality | dtd_identifier |
is_self_referencing | is_identity | identity_generation |
identity_start | identity_increment | identity_maximum |
identity_minimum | identity_cycle | is_generated |
generation_expression | is_updatable

---------------+--------------+------------+--------------+------------------+----------------+-------------+-----------+--------------------------+------------------------+-------------------+-------------------------+---------------+--------------------+---------------+--------------------+-----------------------+----------------------+--------------------+-------------------+------------------+----------------+----------------+---------------+-------------+-------------+------------+----------+---------------+--------------+------------+---------------------+----------------+---------------------+-------------+---------------------+----------------+--------------------+------------------+------------------+----------------+--------------+-----------------------+--------------
 draft         | public       | leagues    | benchplayers |
    8 |                | YES         | integer   |
     |                        |                32 |
   2 |             0 |                    |               |
        |                       |                      |
     |                   |                  |                |
       |               |             | draft       | pg_catalog | int4
    |               |              |            |
| 8              | NO                  | NO          |
    |                |                    |                  |
         |                | NEVER        |                       | YES
(1 row)

[/code]

In this query result field 'numeric_precision' is set to 32 and
'numeric_precision_radix' is set to 2.

According to the documentation 'numeric_precision_radix' field should
indicate what radix the value of 'numeric_precision' is stored.

However, even though the radix is 2, the actual value is 32, which is
not a radix 2.

Could someone please shed some light?

Thank you.


В списке pgsql-general по дате отправления:

Предыдущее
От: James Sewell
Дата:
Сообщение: Re: [GENERAL] Generalized pg_stat_statements?
Следующее
От: Jacob Scott
Дата:
Сообщение: Re: [GENERAL] Generalized pg_stat_statements?