How to model government organization hierarchies so that the list can expand and compress

Alex Glaros alexglaros at
Sat Aug 15 01:42:00 CEST 2015

Frank, thanks for describing the terminology of what I'm trying to do.

1. Do the recursive join Postgres examples you linked to, use a data structure where the child has the adjoining parent-ID? Examples look great.

2. Not 100% sure that hierarchical is the perfect solution but will go with that now. Of course some agencies will be at equal levels; will ignore for now.

3. Could not find Laura's response. Was it deleted?

4. Solution will expressed in the DB, not Python.

Much appreciated!


More information about the Python-list mailing list