ClickHouse/clickhouse-jdbc-bridge

PostgreSQL numeric (without precision)

UnamedRus opened this issue · 0 comments

From PostgreSQL docs:

without any precision or scale creates an “unconstrained numeric” column in which numeric values of any length can be
stored, up to the implementation limits. A column of this kind will not coerce input values to any particular scale, whereas 
numeric columns with a declared scale will coerce input values to that scale. (The SQL standard requires a default scale 
of 0, i.e., coercion to integer precision. We find this a bit useless. If you're concerned about portability, always specify the 
precision and scale explicitly.)

Basically it does mean that ClickHouse or jdbc bridge will throw away decimal part of numeric column