xyz814的博客

示例数据库为postgre:# 1. insert ：create or replace function aa1() returns   void AS $$  declare num integer;  declare sname char;    begin     num := 0;  while num <=44 loop    insert into  system values...

- 创建function CREATE OR REPLACE FUNCTION user() RETURNS trigger AS $BODY$ BEGIN     NEW.ID := nextval('user$seq');     RETURN NEW; END; $BODY$   LANGUAGE 'plpgsql'; - 创建trigger CREATE TRIGGER user     ...