from Hacker News

SQL Tip: JSONB_AGG in PostgreSQL for simple one-to-many joins

by geekuillaume on 8/3/18, 12:49 PM with 3 comments

• by sven_n on 8/3/18, 8:19 PM

  I'm doing this even more extreme... querying a whole complex object graph based on an entity framework core model :) https://github.com/MUnique/OpenMU/blob/master/src/Persistenc...

• by tbrugz on 8/4/18, 3:17 PM

  Oracle has cursor expressions that returns a resultset inside a cell from the parent resultset. The whole resultset could then be serialized to json, xml or whatever

  I wish there was an equivalent function in PostgreSQL. I've even asked a question about that on stackoverflow:

  https://stackoverflow.com/questions/8637050/cursor-inside-sq...

• by zykran on 8/3/18, 12:56 PM

  Nice !