如何在Postgres函数中结合动态SQL的游标中使用函数参数？

CREATE OR REPLACE FUNCTION get_data_by_city(city_name text)
RETURNS TABLE (id integer, name text, city text)
AS $$
DECLARE
    query text;
    cur refcursor;
BEGIN
    -- 构建动态SQL查询语句
    query := 'SELECT id, name, city FROM users WHERE city = $1';

    -- 打开游标
    OPEN cur FOR EXECUTE query USING city_name;

    -- 返回游标结果
    RETURN QUERY FETCH ALL FROM cur;

    -- 关闭游标
    CLOSE cur;
END;
$$ LANGUAGE plpgsql;

SELECT * FROM get_data_by_city('New York');