Hi
I want to try using functions but I am having trouble understanding return.
This is the function -
CREATE OR REPLACE FUNCTION p_id.ip_orient_3()
RETURNS integer AS
$BODY$
Begin
Insert into fluids (fluid_id) values ('1') ;
End;
$BODY$
LANGUAGE 'plpgsql' VOLATILE
COST 100;
ALTER FUNCTION p_id.ip_orient_3() OWNER TO postgres;
This is how I am calling the function -
select p_id.ip_orient_3();
The error message - "control reached end of function without RETURN"
I have attempted adding - Return integer; to the end of the function with no success.
Can anyone help me??
Bob