CREATE OR REPLACE FUNCTION lw.str_fz( str character varying)
RETURNS character varying AS
$BODY$
DECLARE str_fz character varying ;
DECLARE str_sz character varying ;
DECLARE quantity text :='false';
DECLARE tab character varying;
DECLARE tab2 character varying;
declare num int :=-1;
declare l_num int ;
begin
tab2:=str;
loop
l_num:=length(tab2);
num:=num+1;
if l_num>num then
str_fz:=substr(str,length(str)-num,1);
--str_sz:=substr(tab2,num+1,1);
tab:=overlay(tab2 placing str_fz from num+1 for 1 );
--tab:=overlay(tab placing str_sz from l_num-num for 1 );
tab2:=tab;
else
exit;
END IF;
end loop;
quantity :='sucess';
RETURN tab2;
end;
$BODY$
LANGUAGE plpgsql VOLATILE
COST 100;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29050044/viewspace-2127443/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29050044/viewspace-2127443/