Forum OpenACS Development: Response to Patch to allow PL/pgSQL functions to take %TYPE arguments!

Don, would it be a feasible to change the postgres driver to take advantage of this ability to return rows from functions? It seems that the sybase driver does something of the sort, but the Oracle one does not. It might not be important to the database-independent architecture you guys are currently implementing, but down the road it would open up some cool possibilities. Actually, I wish the Oracle driver could do this...

This from the tcl api reference:

ns_db sp_exec executes a stored procedure that has been initialized with ns_db sp_start and ns_db sp_setparam. It returns "NS_DML" if the command was succsesfully executed but did not return rows, or it returns "NS_ROWS" if the command was successfully executed and did return rows (which can then be fetched with ns_db bindrow and ns_db getrow). It throws an error if the command failed. This function is implemented only for the Sybase database driver.