3 ms·

how can you do that with postgres ? a simple example / documentation link ?

• zapov 12y ago
  https://github.com/ngs-doo/revenj/blob/master/tutorials/revenj-tutorial-linq-basics.md https://github.com/ngs-doo/revenj/blob/master/tutorials/reve... SELECT p, array_agg(SELECT c FROM "MasterDetail"."Child_entity" c WHERE c."parentID" = p."ID") as c FROM "MasterDetail"."Parent_entity" p
  • exogen 12y ago
    Note, just replace array_agg with json_agg to get JSON.
  • ddorian43 12y ago
    And doing this the query iterates only once over the MasterDetail table ?
    • zapov 12y ago
      This particular query does a nested loop on the detail table, but basically yes. Only one iteration.