On 10/26/07, Michael Glaesemann <grzm(at)seespotcode(dot)net> wrote:
>
> On Oct 26, 2007, at 4:19 , Gregory Stark wrote:
>
> > "D. Dante Lorenso" <dante(at)lorenso(dot)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