Translate Oracle Trigger to Postgress

ÔÚOracleÖÐÕâÑùµÄtriggerÈçºÎת»»³ÉPostgres,ʵÏÖÒ»ÑùµÄ¹¦ÄÜ£¬Ð»À²
CREATE OR REPLACE TRIGGER  "BI_DELIVERY"
  before insert on "DELIVERY"             
  for each row 
begin 
    select "DELIVERY_SEQ".nextval into :NEW.DELI_ID from dual;
end;

---

mysql ÖбȽÏÊ¡Ê£¬Ö±½ÓÓà AUTO_INCREMENT µÄ×Ö¶ÎÊôÐԾͿÉÒԵõ½×Ôµ½Ôö³¤ÁÐ

CREATE TABLE animals (
    id MEDIUMINT NOT NULL AUTO_INCREMENT,
    name CHAR(30) NOT NULL,
    PRIMARY KEY (id)
);

INSERT INTO animals (name) VALUES
    ('dog'),('cat'),('penguin'),
    ('lax'),('whale'),('ostrich');

SELECT * from animals;

+----+---------+
| id | name    |
+----+---------+
|  1 | dog    |
|  2 | cat    |
|  3 | penguin |
|  4 | lax    |
|  5 | whale  |
|  6 | ostrich |
+----+---------+

---

MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html

---

¿ÉÊÇÏÖÔÚµÄÐèÇó¾ÍÊÇÓÃpostgres£¬Ð»Ð»

ÒýÓÃ

MySQL¹Ù·½Îĵµhttp://dev.mysql.com/doc/refman/5.1/zh/index.html

---