I have the following function:
CREATE or REPLACE FUNCTION public.lov_personinorganization_role_status(
varchar,
varchar)
RETURNS SETOF person_status_in_organization AS
$BODY$
DECLARE
rec person_status_in_organization%ROWTYPE;
role ALIAS FOR $1;
from_status ALIAS FOR $2;
BEGIN
FOR rec IN
SELECT * FROM person_status_in_organization lov,
status_in_organization_change_lov res
WHERE res.role = role
AND res.from_status = from_status
AND lov.role = res.role
AND lov.status = res.to_status
ORDER BY lov.display_order
LOOP
RETURN NEXT rec;
END LOOP; -- FOR rec IN person_status_in_organization
RETURN;
END; -- of lov_personinorganization_role_status
$BODY$
LANGUAGE 'plpgsql' VOLATILE;
Where person_status_in_organization is a table.
When I try to invoke it with:
select lov_personinorganization_role_status('Student','Applicant');
I get the error message:
ERROR: set-valued function called in context that cannot accept a set
CONTEXT: PL/pgSQL function "lov_personinorganization_role_status" line 15 at return next
Where have I gone astray?
~ TIA
~ Ken