-- -- cr_wp_presentations_f/1 -- create or replace function cr_wp_presentations_f( p_new cr_wp_presentationsi ) 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_wp_presentations ( presentation_id, pres_title, page_signature, copyright_notice, style, public_p, show_modified_p ) values (v_revision_id, p_new.pres_title, p_new.page_signature, p_new.copyright_notice, p_new.style, p_new.public_p, p_new.show_modified_p); return; end;$$ language plpgsql;