租户端 数据库 TDSQL PostgreSQL 版 开发指南 循环语句 FOR循环查询结果

FOR循环查询结果

最近更新时间: 2025-02-18 16:02:00

  • 复制
    复制成功
postgres=# CREATE OR REPLACE PROCEDURE p_for_record()  AS
$$    
DECLARE
    v_rec RECORD;
BEGIN           
    FOR v_rec IN SELECT relname,relkind FROM pg_class limit 2 LOOP
        RAISE NOTICE '%',v_rec;
    END LOOP;
END;
$$
LANGUAGE plpgsql;
CREATE PROCEDURE
postgres=# CALL p_for_record();
NOTICE:  (pg_stat_statements,v)
NOTICE:  (pg_proc,v)
CALL
postgres=#