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