14 ms·
The postgres ltree extension does this beautifully. I'm not sure if similar things exist for sqlite or other rdbmses. https://www.postgresql.org/docs/current/l
by jayknight 2y ago
The postgres ltree extension does this beautifully. I'm not sure if similar things exist for sqlite or other rdbmses.
https://www.postgresql.org/docs/current/ltree.html https://www.postgresql.org/docs/current/ltree.html
- halfmatthalfcat 2y agoMSSQL has something similar but no, most other solutions involve recursive queries.