-- -- content_item__write_to_file/2 -- create or replace function content_item__write_to_file( integer, character varying ) returns int4 as $$ declare item_id alias for $1; root_path alias for $2; -- blob_loc cr_revisions.content%TYPE; -- v_revision cr_items.live_revision%TYPE; begin -- FIXME: raise NOTICE 'not implemented for postgresql'; /* v_revision := content_item__get_live_revision(item_id); select content into blob_loc from cr_revisions where revision_id = v_revision; if NOT FOUND then raise EXCEPTION '-20000: No live revision for content item % in content_item.write_to_file.', item_id; end if; PERFORM blob_to_file(root_path || content_item__get_path(item_id), blob_loc); */ return 0; end;$$ language plpgsql;