return setof
setof:
返回多行结果集:
digoal=# CREATE TYPE compfoo AS (f1 int, f2 text); CREATE TYPE digoal=# CREATE FUNCTION textst() RETURNS SETOF compfoo AS $$ digoal$# SELECT fooid, fooname FROM foo digoal$# $$ LANGUAGE SQL; CREATE FUNCTION digoal=# select textst(); textst ------------------- (4,six) (5,two) (7,rrr) (6,vvvvv) (1,nnnn) (7,"") (8,"{bar,beque}") (7 rows)