我的数据库版本是 Postgresql 8.4.7 。 下面是出错的存储过程：

@H_301_5@CREATE or Replace FUNCTION func_getnextid( tablename varchar(240),idname varchar(20) default 'id') RETURNS integer AS $funcbody$ Declare sqlstring varchar(240); currentId integer; Begin sqlstring:= 'select max("' || idname || '") into currentId from "' || tablename || '";'; EXECUTE sqlstring; if currentId is NULL or currentId = 0 then return 1; else return currentId + 1; end if; End; $funcbody$ LANGUAGE plpgsq

执行后出现这样的错误：

sql error:

ERROR:  EXECUTE of SELECT ... INTO is not implemented

CONTEXT:  PL/pgsql function "func_getnextbigid" line 6 at EXECUTE statement

改成这样的就对了：

@H_301_5@CREATE or Replace FUNCTION func_getnextid( tablename varchar(240),idname varchar(20) default 'id') RETURNS integer AS $funcbody$ Declare sqlstring varchar(240); currentId integer; Begin sqlstring:= 'select max("' || idname || '") from "' || tablename || '";'; EXECUTE sqlstring into currentId; if currentId is NULL or currentId = 0 then return 1; else return currentId + 1; end if; End; $funcbody$ LANGUAGE plpgsql;