涛哥,涛哥,求助
<![CDATA[
CREATE OR REPLACE FUNCTION test(code bigint) RETURNS setof zh_cn."Region" AS
$BODY$
DECLARE
rec zh_cn."Region"%rowtype;
BEGIN
IF code > 1000 THEN
FOR rec IN SELECT "Code", "Name" FROM zh_cn."Region" WHERE SUBSTR(CAST("Code" AS text),1,4) = CAST(code AS TEXT)
and CAST("Code" AS TEXT) != CONCAT(CAST(code AS TEXT),'00')
LOOP
RETURN NEXT rec;
END LOOP;
ELSEIF code > 100 and code < 1000 THEN
FOR rec IN SELECT "Code", "Name" FROM zh_cn."Region" WHERE SUBSTR(CAST("Code" AS text),1,3) = CAST(code AS TEXT)
and CAST("Code" AS TEXT) != CONCAT(CAST(code AS TEXT),'000')
LOOP
RETURN NEXT rec;
END LOOP;
ELSEIF code > 10 and code < 100 THEN
FOR rec IN SELECT "Code", "Name" FROM zh_cn."Region" WHERE SUBSTR(CAST("Code" AS text),1,2) = CAST(code AS TEXT)
and CAST("Code" AS TEXT) != CONCAT(CAST(code AS TEXT),'0000')
LOOP
RETURN NEXT rec;
END LOOP;
END IF;
END;
$BODY$
LANGUAGE 'plpgsql';
SELECT test(#{code});
]]>
在使用mybatis框架时,select部分写了一个过程,涛哥帮忙下,我这边总是报空指针异常,我估计可能是过程有问题,求指教