All pastes #798967 Raw Edit

Someone

public text v1 · immutable
#798967 ·published 2007-11-27 04:44 UTC
rendered paste body
CREATE OR REPLACE FUNCTION TeamNamesByAge(teamDivision CHAR) RETURNS SETOF teams AS
$BODY$
DECLARE
    r teams%rowtype;
BEGIN
    FOR r IN SELECT tname FROM teams
    WHERE agid = teamDivision
    LOOP
        RETURN NEXT r; 
    END LOOP;
    RETURN;
END
$BODY$
LANGUAGE 'plpgsql' ;

SELECT tname FROM TeamNamesByAge('ag1');