n the application with one call to the
database and a simple recursive method in a class, though, so I'm not
going to use a stored function in the DB.
Thanks again for responding.
Chas.
Tom Lane wrote:
"Charles F. Munat" <[EMAIL PROTECTED]> writes:
Using pseudocode from
I have a table of organizations that has a many-to-many relationship
with itself via another table called relationships. The relationships
table has a serial id primary key and parent_id and child_id integer
fields. The organizations table has a couple thousand records and the
maximum depth is
I have a table of organizations that has a many-to-many relationship
with itself via another table called relationships. The relationships
table has a serial id primary key and parent_id and child_id integer
fields. The organizations table has a couple thousand records and the
maximum depth is aro