Re: Column information

On 05/03/2017 08:18 PM, Igor Korot wrote:
> 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?

What Postgres version?

Also the data_type is showing as integer not numeric so the numeric_*
values should be NULL.

What is the schema definition for the table?

When I run the query:

production=# select version();
version

-----------------------------------------------------------------------
PostgreSQL 9.6.2 on x86_64-pc-linux-gnu, compiled by gcc (SUSE Linux)
4.8.5, 64-bit
(1 row)

production=# \d projection

...

qty | numeric(7,2) | not null default 0

...

production=# \x
Expanded display is on.

production=# select * from information_schema.columns where table_name
='projection' and column_name='qty';

...

numeric_precision | 7
numeric_precision_radix | 10
numeric_scale | 2

....

>
> Thank you.
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com