Re: DONT_CARE Aggregate

[Richard Broersma <richard.broersma@xxxxxxxxx>]

On Thu, Dec 20, 2012 at 5:45 AM, Robert James <srobertjames@xxxxxxxxx> 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.