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