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
>