CREATE OR REPLACE FUNCTION public.pd_update_category(p_id integer, p_name character varying, p_description character varying, p_img character varying)
 RETURNS integer
 LANGUAGE plpgsql
AS $function$
  begin
	IF p_id <= 0 THEN

	  INSERT INTO pd_category ( name, description, img )
		VALUES(  p_name, p_description,  p_img );
	  p_id= lastval();

	ELSE

	  UPDATE pd_category set name= p_name, description= p_description, img= p_img
		where id= p_id;

	END IF;

	RETURN p_id;

  end
$function$