Depth-first nodetree
Ovid posted an interesting question about how to sort threads in a forum so you'll get the posts that belong to each thread before the next thread starts. Perl part here.
The question is,
Can I do that in straight SQL (this is PostgreSQL 8.4) or should additional information be added to this table?As a matter of fact, in PostgreSQL 8.4 you can do it in straight SQL with no…