-- -- content_revision__to_temporary_clob/1 -- create or replace function content_revision__to_temporary_clob( integer ) returns int4 as $$ declare to_temporary_clob__revision_id alias for $1; -- b blob; -- c text; begin -- FIXME: I cannot find an instance in the 4.2 beta code where this -- is used so I am not worrying about porting it for now. -- DCW - 2001-03-28. raise EXCEPTION 'not implemented content_revision.to_temporary_clob'; /* insert into cr_content_text ( revision_id, content ) values ( revision_id, empty_clob() ) returning content into c; select content into b from cr_revisions where revision_id = to_temporary_clob__revision_id; PERFORM blob_to_clob(b, c); */ return 0; end;$$ language plpgsql;