-- -- cr_news_f/1 -- create or replace function cr_news_f( p_new cr_newsi ) returns void as $$ declare v_revision_id integer; begin select content_revision__new( p_new.title, p_new.description, p_new.publish_date, p_new.mime_type, p_new.nls_language, case when p_new.text is null then p_new.data else p_new.text end, content_symlink__resolve(p_new.item_id), p_new.revision_id, now(), p_new.creation_user, p_new.creation_ip, null, -- content_length p_new.object_package_id ) into v_revision_id; insert into cr_news ( news_id, archive_date, approval_user, approval_date, approval_ip, lead ) values (v_revision_id, p_new.archive_date, p_new.approval_user, p_new.approval_date, p_new.approval_ip, p_new.lead); return; end;$$ language plpgsql;