数据仓库服务 GaussDB(DWS)-RETURN NEXT及RETURN QUERY:示例

时间：2023-11-01 16:15:38

数据仓库服务 GaussDB(DWS) 返回语句

示例

  
       CREATE TABLE t1(a int);INSERT INTO t1 VALUES(1),(10);--RETURN NEXTCREATE 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;call fun_for_return_next(); a--- 1 10(2 rows)-- RETURN QUERYCREATE OR REPLACE FUNCTION fun_for_return_query() RETURNS SETOF t1 AS $$DECLARE   r t1%ROWTYPE;BEGIN   RETURN QUERY select * from t1;END;$$language plpgsql;call fun_for_return_next(); a--- 1 10(2 rows)