Re: [SQL] Function overlaps_interval

2001-04-12 Thread Roberto Mello
On Thu, Apr 12, 2001 at 11:23:28AM -0700, Josh Berkus wrote: > Folks, > > I wrote this PL/pgSQL function for my current project, and thought it > would be generally useful. An expansion of the builtin > overlaps(dt1,dt2,dt3,dt4) function, this function returns the interval > of time for wh

[SQL] Function overlaps_interval

2001-04-12 Thread Josh Berkus
Folks, I wrote this PL/pgSQL function for my current project, and thought it would be generally useful. An expansion of the builtin overlaps(dt1,dt2,dt3,dt4) function, this function returns the interval of time for which the two datetime ranges overlap. Roberto, please include t