2 ms·
If you need to query over a tree data structure, then that's what WITH RECURSIVE is for, and it's present in both DBMS. If you additionally need the result of
by int_19h 3y ago
If you need to query over a tree data structure, then that's what WITH RECURSIVE is for, and it's present in both DBMS.
If you additionally need the result of that query to be hierarchical itself, then you can easily have PG generate JSON for you.