Re: Design of a database table

From: hmidi slim <hmidi(dot)slim2(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Design of a database table
Date: 2018-07-31 06:40:46
Message-ID: CAMsqVxu3vj-fiHHoqbJsmHQQsM4-ARfcQDi9xSD9fHBWCgmm5Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Actually, the data_periods contains a complete range such as
[2018-09-01,2018-09-30] and data_sub_periods contains sub periods contained
in this period like:
[2018-09-05, 2018-09-07]
[2018-09-09, 2018-09-11]
[2018-09-12, 2018-09-19]

I make two conditions in order to fetch first if the period
[2018-09-01,2018-09-30] contained in the first table.If it exists I will
return the sub periods that overlaps the given period
where data_periods.period && '[2018-09-01,2018-09-30]'::daterange
and data_sub_periods && '[2018-09-01,2018-09-30] '::daterange

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lu, Dan 2018-07-31 11:27:36 RE: Question on postgresql.conf
Previous Message David G. Johnston 2018-07-31 05:48:28 Re: Question on postgresql.conf