-- -- content_revision__to_html/1 -- create or replace function content_revision__to_html( integer ) returns int4 as $$ declare to_html__revision_id alias for $1; tmp_clob text; blob_loc integer; begin -- FIXME -- ctx_doc.filter('cr_doc_filter_index', revision_id, tmp_clob); select content into blob_loc from cr_revisions where revision_id = to_html__revision_id for update; PERFORM clob_to_blob(tmp_clob, blob_loc); PERFORM dbms_lob__freetemporary(tmp_clob); return 0; end;$$ language plpgsql;