I'm doing some temporal queries in PostgreSQL and am in need of a way to
find the start/end times for overlapping time segments.
I know about this query, which will tell me whether or not a time
select (timestamp '2001-02-01 0:00', timestamp '2001-09-30 0:00')
overlaps (timestamp '2001-01-01 0:00', timestamp '2001-04-30 0:00');
But I would like to know the actual start/end times for the overlapping
segment (i.e. 2002-02-01 to 2001-04-30). Is there something already
available that will do that, or do I have to write a function to do this?
pgsql-novice by date
|Next:||From: operationsengineer1||Date: 2005-10-07 17:20:28|
|Subject: Set Privileges on All Tables (and/or Sequences) at Once|
|Previous:||From: Lee, Patricia S.||Date: 2005-10-07 15:21:26|
|Subject: Adding a template for new platform|