-- -- search__deindex_etp/0 -- create or replace function search__deindex_etp( ) returns int4 as $$ declare v_txt_row record; begin for v_txt_row in select live_revision from cr_items where parent_id=-400 and live_revision is not null loop perform search_observer__enqueue(v_txt_row.live_revision,'DELETE'); end loop; return 0; end;$$ language plpgsql;