Hi, I have a postgres function returning a set of records (using RETURN NEXT). While calling the function like this:
tasklist = func.get_tasklist(engine=engine).execute() # is this the correct way? I am getting this error: SQLError: ('(ProgrammingError) set-valued function called in context that cannot accept a set\nCONTEXT: PL/pgSQL function "get_tasklist" line 6 at return next\n', <bound method TaskController.get_tasks of <gcollab.controllers.task.TaskController object at 0xb742716c>>) 'SELECT get_tasklist()' {} Am I calling the stored procedure correctly? Need help. thanks Sanjay Here is code of the stored procedure: CREATE OR REPLACE FUNCTION get_tasklist() RETURNS setof tasklist_t AS $ $ DECLARE t tasklist_t%rowtype; BEGIN FOR t IN SELECT task_id, descr, 'Waiting', remind_at, 'Sanjay' FROM task LOOP RETURN NEXT t; END LOOP; RETURN; END; $$ LANGUAGE PLPGSQL; --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---