-- -- 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;