Postgresql存储过程返回表所有列

概述创建一个函数.该函数有一个输入参数.我可以返回一列,但我想返回所有表列.另外我想做的是如果结果为零,则函数返回0.我怎么能这样做？ 这里是错误结果. ERROR: query has no destination for result data HINT: If you want to discard the results of a SELECT, use PERFORM instead. CO 创建一个函数.该函数有一个输入参数.我可以返回一列,但我想返回所有表列.另外我想做的是如果结果为零,则函数返回0.我怎么能这样做？
这里是错误结果.

ERROR: query has no destination for result data
HINT: If you want to discard the results of a SELECT,use PERFORM instead.
CONTEXT: PL/pgsql function DWgCould.returnallcolumns(character varying) line 3 at sql statement
********** Error **********
ERROR: query has no destination for result data
sql state: 42601
Hint: If you want to discard the results of a SELECT,use PERFORM instead.
Context: PL/pgsql function DWgCould.returnallcolumns(character varying) line 3 at sql statement

CREATE OR REPLACE FUNCTION DWgCould.returnallcolumns(IN sessionID character varying)  RETURNS SetoF public.mytable AS$BODY$BEGIN    SELECT * FROM public.mytable WHERE session_ID=returnallcolumns.sessionID ORDER BY pro_ID DESC liMIT 1;END;$BODY$LANGUAGE plpgsql VolATILECOST 100;

如果要返回结果,则需要在PL / pgsql as documented in the manual中使用返回查询

CREATE OR REPLACE FUNCTION DWgCould.returnallcolumns(IN sessionID character varying)  RETURNS SetoF public.mytable AS$BODY$BEGIN  return query --<< this was missing    SELECT *     FROM public.mytable     WHERE session_ID = returnallcolumns.sessionID     ORDER BY pro_ID DESC liMIT 1;END;$BODY$LANGUAGE plpgsql VolATILE;

但是你不需要PL / pgsql,一个简单的sql函数会更有效：

CREATE OR REPLACE FUNCTION DWgCould.returnallcolumns(IN sessionID character varying)  RETURNS SetoF public.mytable AS$BODY$    SELECT *     FROM public.mytable     WHERE session_ID = returnallcolumns.sessionID     ORDER BY pro_ID DESC liMIT 1;$BODY$LANGUAGE sql;

总结

以上是内存溢出为你收集整理的Postgresql存储过程返回表所有列全部内容，希望文章能够帮你解决Postgresql存储过程返回表所有列所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。