Hi guys, I have a problem with a sipmle function in postgresql. The func() calculates two integers to a result and returns it. The result is in the DB, but not in the Console Line in C#. So for example when i have par1 = 2 and par2 = 5 I get an DB entry with 7 in the result row, but the ConsoleLine is empty.
What is wrong here?
BEGIN Result := par1 + par2; insert into t1 (par1, par2, res) values (par1, par2, Result); RETURN Result; END;$BODY$ LANGUAGE plpgsql VOLATILE COST 100; ALTER FUNCTION test_func(integer, integer) OWNER TO "Test";