Postgres Pro
Downloads
Home   >   mailing lists

Re: DONT_CARE Aggregate - Mailing list pgsql-general

From Sergey Konoplev
Subject Re: DONT_CARE Aggregate
Date
Msg-id CAL_0b1uVcdNBO_90wVCU+MCUiA7J4qPNDy1B9DXP94dBwbohJg@mail.gmail.com
Whole thread Raw
In response to DONT_CARE Aggregate  (Robert James <srobertjames@gmail.com>)
Responses Re: DONT_CARE Aggregate
List pgsql-general
Tree view 
On Wed, Dec 19, 2012 at 5:28 PM, Robert James <srobertjames@gmail.com> wrote:
> And even better:
> An aggregate which will return the first instance that meets a certain
> predicate?

Take a look at DISTINCT ON.

--
Sergey Konoplev
Database and Software Architect
http://www.linkedin.com/in/grayhemp

Phones:
USA +1 415 867 9984
Russia, Moscow +7 901 903 0499
Russia, Krasnodar +7 988 888 1979

Skype: gray-hemp
Jabber: gray.ru@gmail.com

pgsql-general by date:

Previous
From: Anjali Arora
Date:
Subject: Re: Vacuum analyze verbose output
Next
From: Heikki Linnakangas
Date:
Subject: Re: [COMMITTERS] pgsql: Allow a streaming replication standby to follow a timeline switc