PostgreSQL

概述--------------存储过程 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_publishe

--------------存储过程

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 '省份英文名称';

总结

以上是内存溢出为你收集整理的PostgreSQL全部内容，希望文章能够帮你解决PostgreSQL所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。