4 ms·

Postgres/Oracle supports such constructs. And Revenj has been using it for years: https://github.com/ngs-doo/revenj https://github.com/ngs-doo/revenj And yes,

by zapov 12y ago

Postgres/Oracle supports such constructs. And Revenj has been using it for years: https://github.com/ngs-doo/revenj https://github.com/ngs-doo/revenj And yes, Revenj now comes with an offline compiler ;)

ddorian43 12y ago
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.