I'm trying/failing to write a recursive plpgsql function where the function tries to operate on a hierary of records in a reflexive table. parent-child-grandchild type of recursion.
I tried with a cursor, but got a "cursor already in use" error. So that looks like scoping.
I know I did this sort of thing in the past, but I can't remember if I used cursors or some other construct to traverse the hierarchy.
Recursive common-table-expression queries would be the typical way. Perhaps that's what you used before