I see. What if I need to do this along with an Aggregate Query. Eg
something like:
SELECT x,y,z, MAX(a), MAX(b), DONT_CARE_AS_LONG_AS_NOT_NULL(c),
DONT_CAR_AS_LONG_AS_P_IS_TRUE(d,p)
...
GROUP BY x,y,z
On 12/20/12, Richard Broersma <richard.broersma@gmail.com> wrote:
> On Thu, Dec 20, 2012 at 5:45 AM, Robert James
> <srobertjames@gmail.com>wrote:
>
>> Sergey - That's an interesting option, but I'm not sure how to use it
>> as an aggregate. Could you give an example?
>>
>
> Here is an example:
>
> buildinghac=>
> SELECT itemnbr, buildingnbr
> FROM Actionitems
> ORDER BY buildingnbr
> LIMIT 10;
> itemnbr | buildingnbr
> ---------+-------------
> 1181 | B-0106
> 363 | B-0106
> 185 | B-0106
> 483 | B-0106
> 67 | B-0106
> 125 | B-0106
> 303 | B-0106
> 245 | B-0106
> 68 | B-0107
> 304 | B-0107
> (10 rows)
>
>
> buildinghac=>
>
> SELECT DISTINCT ON ( buildingnbr )
> itemnbr, buildingnbr
> FROM Actionitems
> ORDER BY buildingnbr
> LIMIT 10;
> itemnbr | buildingnbr
> ---------+-------------
> 245 | B-0106
> 364 | B-0107
> 1170 | B-0111
> 361 | B-0112
> 128 | B-0116
> 1013 | B-0117
> 129 | B-0118
> 368 | B-0300
> 1141 | B-0307
> 74 | B-0423
> (10 rows)
>
>
> --
> Regards,
> Richard Broersma Jr.
>