Mitchell,

> What I didn't understand, is that if I stepped through the original
> procedure, I could see the recursion happenning, it appears to be
> working properly including hitting the suspends as it backs out of the
> recursive stack, but only the one row was produced.

What debugger where you using?

Mind you -- Firebird does not have a debugging interface, so
any development tool you're using emulates Firebirds behaviour.

Not all tools are very good at that... I hope you're not using ours ;-)

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com