--------------存储过程
CREATE OR REPLACE FUNCTION publisherCursor() RETURNS void AS $$ DECLARE -- 定义游标. cur_publisher CURSOR FOR select p.publisher_id as publisher_id,g.id as g_id from t_publisher p join t_publisher_group g on g.publisher_id=p.group_id where group_property=1; -- 定义存储数据的变量. v_publisher_id t_publisher.publisher_id%TYPE; v_g_id t_publisher.group_id%TYPE; BEGIN -- 打开游标. OPEN cur_publisher; -- 填充数据. FETCH cur_publisher INTO v_publisher_id,v_g_id; -- 假如检索到了数据,才处理. while found loop update t_publisher set group_id=v_g_id where publisher_id=v_publisher_id; -- 填充下一条数据. FETCH cur_publisher INTO v_publisher_id,v_g_id; end loop; -- 关闭游标 CLOSE cur_publisher; END; $$ LANGUAGE plpgsql;
------------------------------------增加字段
alter table t_province add province_name_en_us varchar(500); COMMENT ON COLUMN "t_province"."province_name_en_us" IS '省份英文名称'; (编辑:李大同)
【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!
|