Home > mailing lists

range data type size not mention in docs. - Mailing list pgsql-docs

From	Jian He
Subject	range data type size not mention in docs.
Date	February 17, 2022 09:09:55
Msg-id	CAMV54g35XSAq=+RL6H5W+8F7UG-s9eaDNNCTRuEGy76Vo+GGXw@mail.gmail.com Whole thread Raw
Responses	Re: range data type size not mention in docs. ("David G. Johnston" <david.g.johnston@gmail.com>)
List	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.

From: Tom Lane
Date: 16 February 2022, 19:18:46
Subject: Re: Does the POSITION() function takes into account the COLLATION... or not ?!?

From: "David G. Johnston"
Date: 17 February 2022, 09:51:02
Subject: Re: range data type size not mention in docs.