CREATE OR REPLACE FUNCTION addaddress( address character varying, age integer, name character varying, sex character varying, phonenbr character varying ) RETURNS integer AS $BODY$ BEGIN INSERT INTO address ( address, age, name,sex,phonenbr) VALUES( address, age, name,sex,phonenbr); return 0; END; $BODY$ LANGUAGE plpgsql VOLATILE