createFile

create function addNewFile(newName varchar(50), newPath varchar(100), newIdNode int,  newSize int, newDateChange date,newDateEntry date, newDateCreation date)
returns varchar(10) as $$
begin
if exists (select * from File where name = newName and path = newPath and idNode = newIdNode)
then return 'failure';
else
insert into File(name,path,idNode,size,dateChange,dateEntry,dateCreation) values
(newName,newPath,newIdNode,newSize,newDateChange,newDateEntry,newDateCreation);
return 'success';
end if;
end;
$$ LANGUAGE plpgsql;