range data type size not mention in docs.

From: Jian He <hejian(dot)mark(at)gmail(dot)com>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: range data type size not mention in docs.
Date: 2022-02-17 06:09:55
Message-ID: CAMV54g35XSAq=+RL6H5W+8F7UG-s9eaDNNCTRuEGy76Vo+GGXw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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.

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message David G. Johnston 2022-02-17 06:51:02 Re: range data type size not mention in docs.
Previous Message Tom Lane 2022-02-16 16:18:46 Re: Does the POSITION() function takes into account the COLLATION... or not ?!?