Hacker News new | past | comments | ask | show | jobs | submit login
SQL Tip: JSONB_AGG in PostgreSQL for simple one-to-many joins (medium.com/geekuillaume)
16 points by geekuillaume on Aug 3, 2018 | hide | past | favorite | 3 comments

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...

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:


Nice !

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact