Ovid <curtis_ovid_poe(at)yahoo(dot)com> writes:
> My apologies. This isn't PG-specific, but since this is running on PostgreSQL 8.4, maybe there are specific features which might help.
> I have a tree structure in a table and it uses materialized paths to allow me to find children quickly. However, I also need to sort the results depth-first, as one would expect with threaded forum replies.
I think contrib/ltree might help you here. However, it seems to sort
node names textually rather than numerically, so you might need to
change it a bit for your own purposes.
regards, tom lane