public inbox for [email protected]  

help / color / mirror / Atom feed

From: Jian He <[email protected]>
To: [email protected]
Subject: range data type size not mention in docs.
Date: Thu, 17 Feb 2022 11:39:55 +0530
Message-ID: <CAMV54g35XSAq=+RL6H5W+8F7UG-s9eaDNNCTRuEGy76Vo+GGXw@mail.gmail.com> (raw)

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.

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: range data type size not mention in docs.
  In-Reply-To: <CAMV54g35XSAq=+RL6H5W+8F7UG-s9eaDNNCTRuEGy76Vo+GGXw@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox