Re: Getting the amount of overlap when using OVERLAPS

Поиск
Список
Период
Сортировка
От gregstumph@gmail.com
Тема Re: Getting the amount of overlap when using OVERLAPS
Дата
Msg-id 1127500224.007782.158330@g49g2000cwa.googlegroups.com
обсуждение исходный текст
Ответ на Getting the amount of overlap when using OVERLAPS  (Tony Wasson <ajwasson@gmail.com>)
Ответы Re: Getting the amount of overlap when using OVERLAPS  (Tony Wasson <ajwasson@gmail.com>)
Список pgsql-general
I don't think your algorithm for calculating the number of days in the
overlap will work. Picture a scenario where we have one date range that
covers 100 days, and another that covers 10 days, and they overlap by 2
days. Doing "age(<first range>) - age(<second range>)" will return 90
days, not 2 days.


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

Предыдущее
От: Robert Treat
Дата:
Сообщение: Re: How many insert + update should one transaction
Следующее
От: Ron Mayer
Дата:
Сообщение: tsearch2 for alphabetic character strings & codes