postgres=# select pg_column_size(0::smallint);
pg_column_size
----------------
2
(1 row)
postgres=# select pg_column_size(0::integer);
pg_column_size
----------------
4
(1 row)
postgres=# select pg_column_size(0::bigint);
pg_column_size
----------------
8
postgres=# select pg_column_size(10000000000000000::decimal(20));
pg_column_size
----------------
8
(1 row)
postgres=# select pg_column_size(1000000000000000000000001::decimal(30));
pg_column_size
----------------
20
(1 row)
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<maven.compiler.source>11</maven.compiler.source>
<maven.compiler.target>11</maven.compiler.target>
</properties>
<plugin>
<artifactId>maven-compiler-plugin</artifactId>
<version>3.8.0</version>
</plugin>
Content-Type: text/html; charset=utf-8
<meta charset="UTF-8">