Postgres Pro
Downloads
Home   >   mailing lists

Re: Find overlapping time intervals, how? - Mailing list pgsql-general

From joe.celko@northface.edu (--CELKO--)
Subject Re: Find overlapping time intervals, how?
Date
Msg-id a264e7ea.0309091718.4c78863b@posting.google.com
Whole thread Raw
In response to Find overlapping time intervals, how?  (Holger Marzen <holger@marzen.de>)
List pgsql-general
Tree view 
>> 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.

pgsql-general by date:

Previous
From: expect
Date:
Subject: Re: mysql create table -> psql
Next
From: "Konstantin Goudkov"
Date:
Subject: Temp tables and copy