CREATE OR REPLACE FUNCTION getNextIds (VARCHAR,INTEGER) RETURNS VARCHAR AS $body$
DECLARE str VARCHAR ;
DECLARE nextid VARCHAR ;
BEGIN
str = '';
FOR i in 1..$2 loop
nextid = (SELECT NEXTVAL($1));
str = str || nextid || ';' ;
END loop;
RETURN str ;
END ;
$body$
LANGUAGE 'plpgsql';
pgsql 通过 序列 批量获取ID
最新推荐文章于 2024-07-18 07:45:03 发布