Re: [GENERAL] Column information

On 05/04/2017 07:00 AM, Tom Lane wrote:
> Igor Korot  writes:
>> Yes, so for the Radix 2 only 0 and 1 should be used, right?
>> And so the value should be 100000 and not 32.
>
> No, certainly not.  The radix column says what the units of measurement
> are, not that the values in the precision column aren't decimal.  So radix
> 2 indicates that precision 32 means "32 bits", not "32 decimal digits".

Alright now I am confused:

https://www.postgresql.org/docs/9.6/static/infoschema-columns.html

"numeric_precision 	cardinal_number 	

If data_type identifies a numeric type, this column contains the 
(declared or implicit) precision of the type for this column. The 
precision indicates the number of significant digits. It can be 
expressed in decimal (base 10) or binary (base 2) terms, as specified in 
the column numeric_precision_radix. For all other data types, this 
column is null.

"
>
> 			regards, tom lane
>
>


-- 
Adrian Klaver
adrian.klaver@aklaver.com