Re: DONT_CARE Aggregate - Mailing list pgsql-general

From Robert James
Subject Re: DONT_CARE Aggregate
Date
Msg-id CAGYyBggdErerANnvR9Bqrk8ORmSHnZpfAVz=Xg+XfEeU6b6mpw@mail.gmail.com
Whole thread Raw
In response to Re: DONT_CARE Aggregate  (Sergey Konoplev <gray.ru@gmail.com>)
Responses Re: DONT_CARE Aggregate  (Richard Broersma <richard.broersma@gmail.com>)
List pgsql-general
Sergey - That's an interesting option, but I'm not sure how to use it
as an aggregate.  Could you give an example?

On 12/20/12, Sergey Konoplev <gray.ru@gmail.com> wrote:
> 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: Heikki Linnakangas
Date:
Subject: Re: [COMMITTERS] pgsql: Allow a streaming replication standby to follow a timeline switc
Next
From: Vick Khera
Date:
Subject: Re: Any experience with Drobo SAN and PG?