On 8/2/06, bruce <[EMAIL PROTECTED]> wrote:
hi...
i have a tbl
fooTBL
name
parentID
ID
so a name can have might have a parentID, as well as an ID. 'name's are
associated with other 'name's via the parentID. in other words, if a name's
parentID == a name's ID, name1 is the parent of name2.
name parentID ID
foo - 1
cat 1 2
dog 2 3
my question, how can i come up with a sql query that will list all the
children (and children's children...) of a top level item?
i had done this awhile ago.. but can't recall how i did it..
you can try tablefunc contrib module, or recursive pl/pgsql
http://people.planetpostgresql.org/merlin/index.php?/archives/2-Dealing-With-Recursive-Sets-With-PLPGSQL.html
merlin
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
