Re: [GENERAL] PL/pgSQL graph enumeration function hangs

2008-06-07 Thread Charles F. Munat
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

[GENERAL] PL/pgSQL graph enumeration function hangs

2008-06-05 Thread Charles F. Munat
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

[GENERAL] PL/pgSQL graph enumeration function hangs

2008-06-05 Thread Charles F. Munat
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