Re: Custom tstzrange with importance factored in

2023-10-25 Thread Jeff Davis
On Fri, 2023-10-06 at 16:55 +0300, Rares Pop (Treelet) wrote: > 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. I

Custom tstzrange with importance factored in

2023-10-06 Thread Rares Pop (Treelet)
Hi, I want to make a custom range (and multirange type) that carries a few useful details. 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