--
-- content_search__itrg/0
--
create or replace function content_search__itrg(
  
) returns trigger as $$

begin
if (select live_revision from cr_items where item_id=new.item_id) = new.revision_id and new.publish_date >= current_timestamp then
        perform search_observer__enqueue(new.revision_id,'INSERT');
    end if;
    return new;
end;$$ language plpgsql;