gistfile1.sql

presidentuncletom=# SELECT name, ARRAY(SELECT (title, id) FROM groups_map RIGHT OUTER JOIN
 groups ON (groups_map.group_id = groups.id) WHERE groups_map.item_id=person.id)
 AS groups FROM person;
      name       |                       groups
-----------------+----------------------------------------------------
 Harley Earl     | {}
 Henry Ford      | {"(\"industry mogul\",1)","(\"capital mogul\",2)"}
 Rick Wagoner    | {}
 Alfred P. Sloan | {"(\"industry mogul\",1)","(\"capital mogul\",2)"}
 Bob Eaton       | {}
 Howard Shultz   | {}
 Warren Buffet   | {}
 Jamie Dimon     | {}
 Michael Eisner  | {}
 Charlie Munger  | {}
 Lee Iacocca     | {}
 Bob Lutz        | {}
 Fritz Henderson | {}
 Ken Chennault   | {}
 Lew Wasserman   | {"(\"industry mogul\",1)"}
(15 rows)