From: "Rares Pop (Treelet)" <rares@treelet.net>
Content-Type: text/plain;
	charset=us-ascii
Content-Transfer-Encoding: quoted-printable
Mime-Version: 1.0
Subject: Custom tstzrange with importance factored in
Message-Id: <8CB43014-79BC-4FA4-9838-A17313D525F9@treelet.net>
Date: Fri, 6 Oct 2023 16:55:18 +0300
To: pgsql-hackers@lists.postgresql.org
Archived-At: <https://www.postgresql.org/message-id/8CB43014-79BC-4FA4-9838-A17313D525F9%40treelet.net>
Precedence: bulk

Hi,

I want to make a custom range (and multirange type) that carries a few =
useful details.=20
Looks like I may have to implement the operators, custom functions and =
my own aggregator.
Where can I find the code SQL code for anything that relates to the =
tstzrange range type?

Or would you recommend a different approach?
I essentially want to be able to aggregate multiple tstzranges - each =
range with its own importance. The aggregation would be like a a =
join/intersect where ranges with higher importance override the ones =
with lower importance.

Thanks!
Rares=