Postgres ltree : How to limit the max number of children at any given level?

Asked Jul 14 '22 at 16:11

Active Jul 14 '22 at 16:11

Viewed 140 times

I'm working on a reddit-like application that has comment trees, and am in the process of adding tree-paging: IE instead of returning the entire tree, I need to limit the number of results returned.

For example:

The top level might have 15k replies.
A deeply nested comment might have 2 replies.
A simple SQL sort and limit will probably only contain the top level.

I need to create a postgres LIMIT query, that can limit the maximum # of children at any given level, to say 10 replies.

Is there any way to do this with ltrees, without doing queries for every single leaf?

asked Jul 14 '22 at 16:11

dessalines

6,352
5
42
59

Another way to phrase this, would be how do I use limit and offset with a tree to limit the number of results? – dessalines Jul 26 '22 at 14:37
Did you find an answer to this? – sudoExclaimationExclaimation Jul 10 '23 at 01:52
Unfortunately not yet. – dessalines Aug 01 '23 at 22:42

Postgres ltree : How to limit the max number of children at any given level?

0 Answers0