On 10/26/07, Michael Glaesemann <grzm@xxxxxxxxxxxxxxx> wrote:
>
> On Oct 26, 2007, at 4:19 , Gregory Stark wrote:
>
> > "D. Dante Lorenso" <dante@xxxxxxxxxxx> 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
