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