--1.存储过程dome
create or replace procedure Test_leng()
language plpgsql
as $Test_leng$
declare
var_d varchar(50);
begin
insert into lengtest2(mo_sn)values('sdf');
end;
$Test_leng$;
--2.function 写法
create or replace function LengTest() returns text
language plpgsql
as $LengTest1$
begin
return 'M';
end;
$LengTest1$
;
select LengTest()