checking the gaps in intervals

Поиск
Список
Период
Сортировка
От Anton Gavazuk
Тема checking the gaps in intervals
Дата
Msg-id -3205649711969780110@unknownmsgid
обсуждение исходный текст
Ответы Re: checking the gaps in intervals  (Andreas Kretschmer <akretschmer@spamfence.net>)
Re: checking the gaps in intervals  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
Re: checking the gaps in intervals  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
Список pgsql-sql
Hi dear community,

Have probably quite simple task but cannot find the solution,

Imagine the table A with 2 columns start and end, data type is date

start          end
01 dec.     10 dec
11 dec.     13 dec
17 dec.     19 dec
.....

If I have interval, for example, 12 dec-18 dec, how can I determine
that the interval cannot be fully covered by values from table A
because of the gap 14-16 dec? Looking for solution and unfortunately
nothing has come to the mind yet...

Thanks,
Anton

В списке pgsql-sql по дате отправления:

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: Calling the CTE for multiple inputs
Следующее
От: Anton Gavazuk
Дата:
Сообщение: checking the gaps in intervals