Call volume query - Mailing list pgsql-general

From Mike Diehl
Subject Call volume query
Date
Msg-id 1233269836.13476.10.camel@ubuntu
Whole thread Raw
List pgsql-general
Hi all.

I've encountered an SQL problem that I think is beyond my skills...

I've got a table full of records relating to events (phone calls, in
this case) and I need to find the largest number of events (calls)
occurring at the same time.

The table had a start timestamp and a duration field which contains the
length of the call in seconds.

I need to find out how many concurrent calls I supported, at peek
volume.

Can this be done in SQL?  Or do I need to write a perl script?

Thank you,
Mike.


pgsql-general by date:

Previous
From: Gregory Stark
Date:
Subject: Re: How relate pg_class to pg_constraint
Next
From: Greg Smith
Date:
Subject: Re: Pet Peeves?