代码
CREATE OR REPLACE FUNCTION getfoo() RETURNS SETOF record AS
$BODY$begin
select * from "MyFirstPGSQL";
end;$BODY$
LANGUAGE 'plpgsql' VOLATILE
COST 100
ROWS 1000;在pgAdmin自带的查询工具中执行
select * from getfoo() as tt(id integer,myname character varying(50),pwd character varying(50));
or
select "getfoo"(); 都报错
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 "getfoo" line 2 at SQL statement
CREATE OR REPLACE FUNCTION getfoo() RETURNS SETOF record AS
$BODY$begin
select * from "MyFirstPGSQL";
end;$BODY$
LANGUAGE 'plpgsql' VOLATILE
COST 100
ROWS 1000;在pgAdmin自带的查询工具中执行
select * from getfoo() as tt(id integer,myname character varying(50),pwd character varying(50));
or
select "getfoo"(); 都报错
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 "getfoo" line 2 at SQL statement
解决方案 »
- mysql的字符集问题
- 使用Mysqlbinlog出现的问题?
- 【mysql】删除表中数据.....前提标题一定要很短很短很短很短很短才行。。。。。。
- 小问题
- 求一SQL语句,谢谢了
- 请教mysql在参数查询时的问题?
- mysql 错误,错误号(2013):ERROR 2013: Lost connection to MySQL server during query
- mysql怎么用money类型的数据?
- 请问这样的数据结构怎么做多条件查询?
- MYSQL 的存储过程总是错.新手问题.求解答
- 求MYSQL下载地址
- 被困2天:查询工具里运行简单的函数报错 query has no destination for result data
试试
需要在 函数中返回复合类型 地方 加上 return queryreturn query select * from "MyFirstPGSQL";我贴上面的 在pgAdmin自带的查询工具中执行语句 是正确的。。第一个坎算过去 谢谢大家!