本文實例講述了postgreSQL存儲過程用法。分享給大家供大家參考，具體如下：

轉(zhuǎn)了N多的SQL語句,可是自己用時,卻到處是坑啊,啊,啊!!!!!!!!!!!!!!!

想寫一個獲取表中最新ID值.

上代碼

CREATE TABLE department(
ID INT PRIMARY KEY NOT NULL,
d_code VARCHAR(50),
d_name VARCHAR(50) NOT NULL,
d_parentID INT NOT NULL DEFAULT 0
);
–insert into department values(1,’001′,’office’);
–insert into department values(2,’002′,’office’,1);