--
-- wp_style__image_delete/1
--
create or replace function wp_style__image_delete(
  integer
) returns int4 as $$

declare 
    p_revision_id       alias for $1;
    v_item_id           integer;
begin
    update wp_styles set background_image = 0 
    where background_image = p_revision_id;

    delete from wp_style_images 
    where wp_style_images_id = p_revision_id;
    
    select item_id into v_item_id from cr_revisions 
    where revision_id = p_revision_id;

    perform content_item__delete(v_item_id);

    return 0;
end;$$ language plpgsql;