MIME-Version: 1.0
From: Jian He <hejian.mark@gmail.com>
Date: Thu, 17 Feb 2022 11:39:55 +0530
Message-ID: 
 <CAMV54g35XSAq=+RL6H5W+8F7UG-s9eaDNNCTRuEGy76Vo+GGXw@mail.gmail.com>
Subject: range data type size not mention in docs.
To: pgsql-docs@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000002bacbd05d8309ea4"
Archived-At: 
 <https://www.postgresql.org/message-id/CAMV54g35XSAq%3D%2BRL6H5W%2B8F7UG-s9eaDNNCTRuEGy76Vo%2BGGXw%40mail.gmail.com>
Precedence: bulk

--0000000000002bacbd05d8309ea4
Content-Type: text/plain; charset="UTF-8"

range type seem not mention their size in the docs.
multi range size is variable.
But range size seems fixed.
why it's 17 byte?

select  pg_column_size('[10,20)' ::int4range ); --17 byte
select  pg_column_size('[-2147483648,2147483647)' ::int4range ); --17 byte.

--0000000000002bacbd05d8309ea4
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div><br></div><div>range type seem not mention their size=
 in the docs.</div><div>multi range size is variable. <br></div><div>But ra=
nge size seems fixed.</div><div>why it&#39;s 17 byte? <br></div><div><pre s=
tyle=3D"background-color:rgb(30,30,30);color:rgb(212,212,212);font-family:&=
quot;JetBrains Mono&quot;,monospace;font-size:9.8pt"><span style=3D"color:r=
gb(73,156,213)">select  </span><span style=3D"color:rgb(220,220,170)">pg_co=
lumn_size</span>(<span style=3D"color:rgb(205,144,105)">&#39;[10,20)&#39; <=
/span>::<span style=3D"color:rgb(211,211,200)">int4range </span>); <span st=
yle=3D"color:rgb(105,152,86)">--17 byte<br></span><span style=3D"color:rgb(=
73,156,213)">select  </span><span style=3D"color:rgb(220,220,170)">pg_colum=
n_size</span>(<span style=3D"color:rgb(205,144,105)">&#39;[-2147483648,2147=
483647)&#39; </span>::<span style=3D"color:rgb(211,211,200)">int4range </sp=
an>); <span style=3D"color:rgb(105,152,86)">--17 byte.</span></pre></div></=
div>

--0000000000002bacbd05d8309ea4--