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

declare
    p_item_id alias for $1;
begin
    update cr_news
    set    archive_date = null
    where  news_id = content_item__get_live_revision(p_item_id);

    return 0;
end;
$$ language plpgsql;