Postgres 使用 pl/pgsql demo (一)
1.创建一个score表
create table score(
sname varchar(30),
score int
);
create table score_good(
sname varchar(30),
score int
);
select * from score;
select * from score_good;
-- 返回一个触发器,当score表发生 新增或更新操作时,
-- 此函数会将分数大于60的学生存放到score_good 表中
create or replace function stu_good()
returns trigger as
'
begin
insert into score_good(sname,score) select sname,score from score where score>60;
return null;
end;
'
language plpgsql volatile;
– 创建相应的触发器
create trigger trg1
after insert or update
on score
for each row execute procedure stu_info();
;
– 测试数据
INSERT INTO “public”.“score” (“sname”, “score”) VALUES (‘kity’,98);