云数据库 GaussDB-RETURN NEXT及RETURN QUERY:示例

时间：2023-11-01 16:22:24

云数据库 GaussDB

示例

  
       postgres=# CREATE TABLE t1(a int);postgres=# INSERT INTO t1 VALUES(1),(10);--RETURN NEXTpostgres=# CREATE OR REPLACE FUNCTION fun_for_return_next() RETURNS SETOF t1 AS $$DECLARE   r t1%ROWTYPE;BEGIN   FOR r IN select * from t1   LOOP      RETURN NEXT r;   END LOOP;   RETURN;END;$$ LANGUAGE PLPGSQL;postgres=# call fun_for_return_next(); a--- 1 10(2 rows)-- RETURN QUERYpostgres=# CREATE OR REPLACE FUNCTION fun_for_return_query() RETURNS SETOF t1 AS $$DECLARE   r t1%ROWTYPE;BEGIN   RETURN QUERY select * from t1;END;$$language plpgsql;postgres=# call fun_for_return_next(); a--- 1 10(2 rows)