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@xxxxxxxxx> wrote: > 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. > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
