求助:
自定义函数里就一句 begin
select * from "Mytable"
end;返回集合 类型[character varying] 若返回[Mytable]类型报一样的错误在查询工具里执行语句
select "returnCollection"()报错 query has no destination for result data
自定义函数里就一句 begin
select * from "Mytable"
end;返回集合 类型[character varying] 若返回[Mytable]类型报一样的错误在查询工具里执行语句
select "returnCollection"()报错 query has no destination for result data
select * from Mytable
end;
把引号去了。
begin
select * from Mytable
end;error: relation "Mytable" dose not exist
select * from "MyFirstPGSQL";
end;$BODY$LANGUAGE 'plpgsql' VOLATILE
COST 100
ROWS 1000;
select * from MyFirstPGSQL;
end
$BODY$begin
select * from "MyFirstPGSQL";
end;$BODY$
LANGUAGE 'plpgsql' VOLATILE
COST 100
ROWS 1000;查询工具
select * from getfoo() as tt(id integer,myname character varying(50),pwd character varying(50));错误
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真上火 怎么都弄不好