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

2015-08-17 Thread Alex Glaros
Perhaps most jointly parented governmental organizations are functionally, collaborative "projects" (not organizations) which my model handles. But thanks to Laura, will not assume there are none, or will never be any in the future, so will use adjacent list (see fast response times documented i

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

2015-08-14 Thread Alex Glaros
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 tha

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

2015-08-13 Thread Alex Glaros
anizational list. Am using Postgres, not graph database. I'm hoping someone else has worked on this problem, probably not with government agency names, but perhaps the same principle with other objects. Thanks! Alex Glaros -- https://mail.python.org/mailman/listinfo/python-list