On 10/26/07, Michael Glaesemann <grzm@seespotcode.net> wrote:
>
> On Oct 26, 2007, at 4:19 , Gregory Stark wrote:
>
> > "D. Dante Lorenso" <dante@lorenso.com> writes:
> >
> >> You need to look at the connectby function which is part of contrib.
> >
> > Or ltree. Depending on how static your data is and what else you
> > need to do
> > with it.
>
> Or adjacency list or nested set (or even nested intervals).
>
> Michael Glaesemann
> grzm seespotcode net
>
>
>

A bunch of options so far...but there's really no way to do this with
standard SQL?

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.

Pat

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq