開發咨詢，想在function返回之前insert或者update的值，postgresql有個returning的特性，可以返回之前各種DML(insert,delete,update)掉的值，比mysql的返回last_insert_id更豐富一點。? 環境：? PostgreSQL 9.3.2? CentOS 6.3? 類似的Function如下： ~~~ CREATE OR REPLACE FUNCTION fun_test(v_id int, v_remark text) RETURNS integer AS $BODY$ declare o_id int; begin perform 1 from foo where id=v_id and remark = v_remark ; if not found then insert into foo(remark) values (v_remark) returning id into o_id; return o_id; else update foo set id=v_id, remark=v_remark where id=v_id and remark = v_remark returning id into o_id; return o_id ; end if; exception when others then raise exception 'exec fun fun_test error,PLZ contact DBA！'; return 999; end; $BODY$ LANGUAGE plpgsql VOLATILE COST 100; ALTER FUNCTION fun_test(int, text) OWNER TO postgres; ~~~ 參考：? http://my.oschina.net/Kenyon/blog/54376? http://my.oschina.net/Kenyon/blog/108303