Home > mailing lists

Re: Good candidate query for window syntax? - Mailing list pgsql-general

From	Dimitri Fontaine
Subject	Re: Good candidate query for window syntax?
Date	September 13, 2010 15:57:57
Msg-id	87tylty6th.fsf@hi-media-techno.com Whole thread Raw
In response to	Good candidate query for window syntax? (Ketema Harris <ketema@gmail.com>)
List	pgsql-general

Tree view

Ketema Harris <ketema@gmail.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

pgsql-general by date:

From: Tom Lane
Date: 13 September 2010, 14:47:34
Subject: Re: User function canceling VACUUMDB utility

From: Greg Smith
Date: 13 September 2010, 16:57:35
Subject: Re: Monitoring Object access

Re: Good candidate query for window syntax? - Mailing list pgsql-general

Previous

Next