create or replace function funcinsert(iacid int, islno int, idate date)
returns int as $$
declare id_val int;begin with i as ( insert into gtab83 (acid,slno,orderdte) values (iacid,islno,idate) returning orderid ) select orderid into id_val from i; return id_val;end;$$ language plpgsql;
It can be much simpler as plain sql
create or replace function funcinsert(iacid int, islno int, idate date)returns int as $$ insert into gtab83 (acid,slno,orderdte) values (iacid,islno,idate) returning orderid ;$$ language sql;
