postgresql7.1 select content_item__new( varchar :name, :parent_id, null, now(), [User::getID], null, '[ns_conn peeraddr]', 'content_item', :content_type, null, null, 'text/plain', null, null, 'text'); -- FIX ME LOB insert into cr_xml_docs values ($revision_id, empty_lob()) returning doc into :1 select content_revision__import_xml(:item_id, :revision_id, :revision_id) select coalesce(content_item__get_path(:parent_id,null), '/') as item_path, pretty_name as content_type_name from acs_object_types where object_type = :content_type select acs_object_id_seq.nextval