Postgres Pro
Downloads
Home   >   mailing lists

Explanation of pg_column_size - Mailing list pgsql-novice

From Steve Baldwin
Subject Explanation of pg_column_size
Date
Msg-id CAKE1Aia-zWD+DxEMU_CFOHFz=G8vPCgTrGdgNuPzk_kK=FsaEw@mail.gmail.com
Whole thread Raw
Responses Re: Explanation of pg_column_size
List pgsql-novice
Tree view
Hi all,

Can someone please explain the following to me:

mse=# with l as (select 0.1::numeric as numlit) select pg_column_size(numlit) as sz_numlit, pg_column_size(0.1::numeric) as sz_expr from l;
 sz_numlit | sz_expr
-----------+---------
         5 |       8
(1 row)

It looks as though the expression is being cast to double precision, but maybe it is invalid to use pg_column_size in this way.

I'm using 9.5.3 on OS X.

Thanks,

Steve

pgsql-novice by date:

Previous
From: gk chinna
Date:
Subject: SUB # How to configure / calculate the semaphore related values while making changes to max_connections
Next
From: Tom Lane
Date:
Subject: Re: Explanation of pg_column_size