Re: Getting the amount of overlap when using OVERLAPS - Mailing list pgsql-general

From gregstumph@gmail.com
Subject Re: Getting the amount of overlap when using OVERLAPS
Date
Msg-id 1127500224.007782.158330@g49g2000cwa.googlegroups.com
Whole thread Raw
In response to Getting the amount of overlap when using OVERLAPS  (Tony Wasson <ajwasson@gmail.com>)
Responses Re: Getting the amount of overlap when using OVERLAPS
List 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 by date:

Previous
From: Robert Treat
Date:
Subject: Re: How many insert + update should one transaction
Next
From: Ron Mayer
Date:
Subject: tsearch2 for alphabetic character strings & codes