PL/pgSQL Cursors

CREATE TABLE Film
(
ID          SERIAL          PRIMARY KEY,
Title       VARCHAR(250)    NOT NULL,
Genre       VARCHAR(50)     NOT NULL,
Released    INTEGER         NOT NULL,
Description VARCHAR(2000)   NOT NULL
);

----------------------------------------------------------------------------------------------------------------------------
INSERT INTO Film(ID, Title, Genre, Released, Description)
VALUES(DEFAULT, 'Avengers: End Game', 'Fantasy/Sci-fi', 2019, 'Adrift in space with no food or water, Tony Stark sends a message to Pepper Potts as his oxygen supply starts to dwindle. Meanwhile, the remaining Avengers -- Thor, Black Widow, Captain America and Bruce Banner -- must figure out a way to bring back their vanquished allies for an epic showdown with Thanos -- the evil demigod who decimated the planet and the universe.');

INSERT INTO Film(ID, Title, Genre, Released, Description)
VALUES(DEFAULT, 'Fast & Furious: Hobbs & Shaw', 'Mystery/Action', 2019, 'Ever since hulking lawman Hobbs (Johnson), a loyal agent of Americas Diplomatic Security Service, and lawless outcast Shaw (Statham), a former British military elite operative, first faced off in 2015’s Furious 7, the duo have swapped smack talk and body blows as they have tried to take each other down. But when cyber-genetically enhanced anarchist Brixton (Idris Elba) gains control of an insidious bio-threat that could alter humanity forever — and bests a brilliant and fearless rogue MI6 agent (The Crown’s Vanessa Kirby), who just happens to be Shaw’s sister — these two sworn enemies will have to partner up to bring down the only guy who might be badder than themselves.
');

INSERT INTO Film(ID, Title, Genre, Released, Description)
VALUES(DEFAULT, 'Captain Marvel', 'Fantasy/Sci-fi', 2019, 'Captain Marvel is an extraterrestrial Kree warrior who finds herself caught in the middle of an intergalactic battle between her people and the Skrulls. Living on Earth in 1995, she keeps having recurring memories of another life as U.S. Air Force pilot Carol Danvers. With help from Nick Fury, Captain Marvel tries to uncover the secrets of her past while harnessing her special superpowers to end the war with the evil Skrulls.');

----------------------------------------------------------------------------------------------------------------------------
CREATE OR REPLACE FUNCTION Get_Title(film_release INTEGER)
    RETURNS TEXT AS $$
DECLARE
    Titles      TEXT        DEFAULT '';
    Record_Film RECORD;
    Cursor_Film CURSOR(film_release INTEGER)
        FOR SELECT Title, Released
        FROM Film
        WHERE Released = film_release;
BEGIN
    OPEN Cursor_Film(film_release);

    LOOP
        FETCH Cursor_Film INTO Record_Film;
        EXIT WHEN NOT FOUND;

        IF Record_Film.Title LIKE '%' THEN
            Titles := Titles || ', ' || Record_Film.Title || ':' || Record_Film.Released;
        END IF;
    END LOOP;

    CLOSE Cursor_Film;

    RETURN Titles;
END; $$

LANGUAGE plpgsql;