postgres中没有目标数据的查询 [英] query that does not have destination data in postgres
问题描述
我有一个表ConfigurationSetting,它有一些像这样的列
创建表ConfigurationSetting(id serial,fbstime character varying(20) ),sbstime字符变化(20),tbstime字符变化(20),Loc_Rep_time字符变化(20),Map_Ref_time字符变化(20),Store_in_cluster字符变化(20),Biker_speed字符变化(20),time_to_cover_distance字符变化(20) )
现在我想创建将数据插入上表的功能,所以功能看起来像这个
创建函数ins_ConfigurationSetting(first_beat_start_time字符变化(20),second_beat_start_time字符变化(20),third_beat_start_time字符变化(20), Loc_Rep_time字符变化(20),Map_Ref_time字符变化(20),Store_in_cluster字符变化(20),Biker_speed字符变化(20),time_to_cover_distance字符变化(20))
返回void as $$
开始
插入ConfigurationSetting(fbstime,sbstime,tbstime,Loc_Rep_time,Map_Ref_time,Store_in_cluster,Biker_speed,time_to_cover_distance)值($ 1,$ 2,$ 3,$ 4,$ 5 ,$ 6,$ 7,$ 8)
返回id;
结束
$$语言'plpgsql';
这个功能成功运行
但是当我调用这样的功能时
select ins_ConfigurationSetting('09:52:33','04:50:33','12:00:00','16:20:00','23:00:00 ','40','20','03');
显示错误
查询没有结果数据的目的地
如何解决
begin
插入ConfigurationSetting(fbstime,sbstime,tbstime,Loc_Rep_time,Map_Ref_time,Store_in_cluster,Biker_speed,time_to_cover_distance)值(
1,
2,
i have a table ConfigurationSetting which have some column like this
create table ConfigurationSetting(id serial, fbstime character varying(20),sbstime character varying(20), tbstime character varying(20),Loc_Rep_time character varying(20),Map_Ref_time character varying(20),Store_in_cluster character varying(20),Biker_speed character varying(20),time_to_cover_distance character varying(20))
now i want to create function that insert data into above table so fuction is look like this
create function ins_ConfigurationSetting(first_beat_start_time character varying(20),second_beat_start_time character varying(20),third_beat_start_time character varying(20),Loc_Rep_time character varying(20),Map_Ref_time character varying(20),Store_in_cluster character varying(20), Biker_speed character varying(20),time_to_cover_distance character varying(20))
returns void as $$
begin
insert into ConfigurationSetting (fbstime,sbstime,tbstime,Loc_Rep_time,Map_Ref_time,Store_in_cluster,Biker_speed,time_to_cover_distance)values($1,$2,$3,$4,$5,$6,$7,$8)
returning id;
end
$$ language 'plpgsql';
this function successfully run
but when i m calling function like this
select ins_ConfigurationSetting('09:52:33','04:50:33','12:00:00','16:20:00','23:00:00','40','20','03');
it show error that
query has no destination for result data
how to resolve that解决方案
begin
insert into ConfigurationSetting (fbstime,sbstime,tbstime,Loc_Rep_time,Map_Ref_time,Store_in_cluster,Biker_speed,time_to_cover_distance)values(
1,
2,
这篇关于postgres中没有目标数据的查询的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!