On Oct 26, 2007, at 10:56 , Pat Maddox wrote:
A bunch of options so far...but there's really no way to do this with
standard SQL?
What do you mean by "standard SQL"? Trees aren't inherently relational.
I'm starting to feel I'm better off just pulling the data I need and
then building the tree structure in my app code.
Part of the issue is how do you *store* the tree in the database. You
have to encode that information somehow. These are all methods to do
that.
Michael Glaesemann
grzm seespotcode net
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
