3 ms·
Because that only gives you actor names, not records, and also because arrays aren't a universal SQL feature.
by RedCrowbar 5y ago
Because that only gives you actor names, not records, and also because arrays aren't a universal SQL feature.
- eatonphil 5y agoEdgeDB is already postgres specific though.
- RedCrowbar 5y agoEdgeDB currently is. Graph-relational and EdgeQL are not.
- SahAssar 5y agoUntil another db is graph-relational and can be queried via edgeql those are just as postgres-specific as arrays though, right?
- nicoburns 5y agoYou can JSON_AGG to get whole records.
- deleted 5y ago[deleted]
- RedCrowbar 5y agoUnfortunately, JSON aggregation destroys type information, so you can't reason about that your SQL query actually returns anymore.