Postgres Pro
Downloads
Home   >   mailing lists

Re: Split daterange into sub periods - Mailing list pgsql-general

From hmidi slim
Subject Re: Split daterange into sub periods
Date
Msg-id CAMsqVxtZa_Pn4nTbjkV9q0mdd0vbtUNXLKmkngC44reJ0xuP4A@mail.gmail.com
Whole thread Raw
In response to Re: Split daterange into sub periods  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Split daterange into sub periods
Re: Split daterange into sub periods
List pgsql-general
Tree view
In fact I'm trying to split a period in sub periods. Following this example :
If I have a period =[2018-01-01, 2018-01-31] and two other periods [2018-01-04, 2018-01-06] and [2018-01-08, 2018-01-08].
If I split the base period '[2018-01-01, 2018-01-31]' by the other two periods '[2018-01-04, 2018-01-06]' and '[2018-01-08, 2018-01-08]' I will got such a result:
[2018-01-01, 2018-01-03]
[2018-01-07, 2018-01-07]
[2018-01-09, 2018-01-31].

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Split daterange into sub periods
Next
From: Francisco Olarte
Date:
Subject: Re: Split daterange into sub periods