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.
