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.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
