Ovid <curtis_ovid_...@yahoo.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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
