CREATE PROCEDURE dbo.add_road(Name_road varchar(200) = NULL,
ShName varchar(50) = NULL, 
Code1 varchar(15) = NULL,
Code2 varchar(15) = NULL,
Type_road varchar(200) = NULL,
INOUT ID_New integer = 0)

LANGUAGE plpgsql   
AS $$
 BEGIN

	select ID_New = max(id_road)+1 from road;

    if (ID_New IS NULL) THEN
       ID_New:=1; 
       
	insert into dbo.road (id_road,name,shname,code1,code2,type) VALUES(ID_New, Name_road, ShName, Code1, Code2, Type_road);
    COMMIT;
	
 END 
$$;

END IF;