return setof

来源:互联网 发布:python async def 编辑:程序博客网 时间:2024/06/05 22:30
setof:
返回多行结果集:

digoal=# CREATE TYPE compfoo AS (f1 int, f2 text);CREATE TYPEdigoal=# CREATE FUNCTION textst() RETURNS SETOF compfoo AS $$digoal$# SELECT fooid, fooname FROM foodigoal$# $$ LANGUAGE SQL;CREATE FUNCTIONdigoal=# select textst(); textst ------------------- (4,six) (5,two) (7,rrr) (6,vvvvv) (1,nnnn) (7,"") (8,"{bar,beque}")(7 rows)


0 0
原创粉丝点击