Re: Finding free time period on non-continous tstzrange field values

[Amitabh Kant <amitabhkant@xxxxxxxxx>]

On Wed, Nov 30, 2022 at 7:20 PM Marcos Pegoraro <marcos@xxxxxxxxxx> wrote:

Given the following table, how do I find free time period.

https://www.crunchydata.com/blog/better-range-types-in-postgres-14-turning-100-lines-of-sql-into-3

Thanks Marcos .. Had seen this earlier but somehow slipped my mind to use it for implementation. Will try implementing using tstzmultirange.