admin 管理员组文章数量: 887021
2023年12月19日发(作者:莎莎源码网不能访问)
ff3."uploadCount"from _fabriccategory ff3inner join _fabriccategory ff2 on ategory_id = and ategory_id = 1596where ff3."name" like nameLikelimit 1;loop
fetch ff3_list into ff3_item;if not found then exit;end if;titles := ff3_ || ',' || ff3_item."name";raise notice 'values: %', titles;ff3_id := ff3_;ff3_id_new = nextval('fabric_fabriccategory_id_seq'::regclass);raise notice 'new ff3 id: %', ff3_id_new;insert into _fabriccategory (id, "name" , "valid" ,"orderValue","level", supercategory_id, "uploadCount")values(ff3_id_new, ff3_item."name", ff3_item."valid",ff3_item."orderValue", ff3_item."level", ff3_ategory_id, ff3_item."uploadCount" );select into fabric_id_o from _fabric ff where ry_id = ff3_id and ff."valid" =true;fabric_id_new = nextval('fabric_fabric_id_seq'::regclass);insert into _fabric (
select fabric_id_new as id, ff."name" ,ff."simulationCount" ,ff."valid" ,_id ,ff3_id_new as category_id ,ff."orderValue"
,, ff."mappingImage", , ,, , ing_id
from _fabric ff where = fabric_id_o);raise notice 'new fabric id: %', fabric_id_new;raise notice 'old fabric id: %', fabric_id_o;INSERT INTO _fabricinformation(select nextval('fabric_fabricinformation_id_seq'::regclass) as id, fabric_id_new as fabric_id , , , ,ition , ,fff."oneRepeatSize" , fff."text"
from _fabricinformation fff where _id =fabric_id_o
);insert into _detailimage (select nextval('fabric_detailimage_id_seq'::regclass) as id, fabric_id_new as fabric_id ,image ,thumb from _detailimage fd
where _id = fabric_id_oorder by asc);end loop;close ff3_list;return ff3_id_new;end$$language plpgsql;
版权声明:本文标题:postgresql存储过程简单应用实例 内容由网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:http://www.freenas.com.cn/jishu/1702974460h438071.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
发表评论