Anonymous

CREATE OR REPLACE FUNCTION testing() RETURNS INTEGER LANGUAGE plpgsql VOLATILE CALLED ON NULL INPUT SECURITY DEFINER AS $$
     DECLARE
      var_id INTEGER;
     BEGIN
                        SELECT id INTO var_id FROM tbl_test WHERE status = 0;
                        IF FOUND THEN
                                        DELETE FROM tbl_test WHERE id = var_id;
                                        RAISE NOTICE 'Failure';
                                        RETURN -1;
                        ELSE
                                        RAISE NOTICE 'Success';
                        END IF;    
          
                        RETURN 0;

     END;
$$;