开发咨询，想在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 thenraise 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