Re: Find overlapping time intervals, how?

From: joe(dot)celko(at)northface(dot)edu (--CELKO--)
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Find overlapping time intervals, how?
Date: 2003-09-10 01:18:39
Message-ID: a264e7ea.0309091718.4c78863b@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>> Now we want to generate a report of the availability. But for a
specific application both servers must be up at the same time. <<

Chapter 13 in SQL FOR SMARTIES. Also see Rick Snodgrass's book on
temporal SQL queries. But first thing, use timestamps or this is
going to be stinking mess.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Konstantin Goudkov 2003-09-10 01:22:34 Temp tables and copy
Previous Message Alvaro Herrera Munoz 2003-09-10 00:17:30 Re: Find overlapping time intervals, how?