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

时间：2025-01-26 10:43:42

云数据库 GaussDB

示例

  
       gaussdb=# DROP TABLE t1;gaussdb=# CREATE TABLE t1(a int);gaussdb=# INSERT INTO t1 VALUES(1),(10);--RETURN NEXTgaussdb=# 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;gaussdb=# call fun_for_return_next(); a--- 1 10(2 rows)-- RETURN QUERYgaussdb=# 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;gaussdb=# call fun_for_return_query(); a--- 1 10(2 rows)