代码
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 group by 一直会using temporary,请问如何优化??
- 求助关于查询时间的问题
- 很有难度的mysql问题,难道是MYSQL的BUG。
- 请教开发人员如何学习MySQL
- 统计每分钟的次数问题!急!
- 复杂的近似度计算应用(sql 算法相关)
- Mysql支持外键吗?
- Can't connect to MySQL server on 'localhoat' (10061)
- 用VC怎么实现两个表的关联啊?
- 求MYSQL下载地址
- 被困2天:查询工具里运行简单的函数报错 query has no destination for result data
试试
需要在 函数中返回复合类型 地方 加上 return queryreturn query select * from "MyFirstPGSQL";我贴上面的 在pgAdmin自带的查询工具中执行语句 是正确的。。第一个坎算过去 谢谢大家!