Re: Good candidate query for window syntax?

From: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
To: Ketema Harris <ketema(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Good candidate query for window syntax?
Date: 2010-09-13 15:57:46
Message-ID: 87tylty6th.fsf@hi-media-techno.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ketema Harris <ketema(at)gmail(dot)com> writes:
> My goal is: To find the maximum number of concurrent rows over an
> arbitrary interval.

My guess is that the following would help you:

http://wiki.postgresql.org/wiki/Range_aggregation

--
dim

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Greg Smith 2010-09-13 16:57:22 Re: Monitoring Object access
Previous Message Jonathan Brinkman 2010-09-13 15:17:51 I keep getting "type does not exist" on compile of this SETOF function (list 2 table)