Re: Sorting with materialized paths

Ovid <curtis_ovid_poe@yahoo.com> writes:
> My apologies. This isn't PG-specific, but since this is running on PostgreSQL 8.4, maybe there are specific features
whichmight help. 
> I have a tree structure in a table and it uses materialized paths to allow me to find children quickly. However, I
alsoneed 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