GREENPLUM的函数返回TABLE

指定表结构方式：

CREATE OR REPLACE FUNCTION ads.fv_repay_detail() RETURNS 
TABLE( product_id bigint, real_date varchar, principal_tot NUMERIC, principal NUMERIC, interest NUMERIC) AS 
$$
SELECT product_id, real_date, principal_tot, principal, interest from tb_repay_plan
$$ LANGUAGE sql;

使用已有表的结构：

CREATE OR REPLACE FUNCTION  table_name1 () RETURNS 
SETOF table_name1 AS 
$body$ 
SELECT * from table_name1; 
$body$ 
LANGUAGE 'sql' VOLATILE CALLED ON NULL INPUT SECURITY INVOKER;