--
-- lob_length/1
--
create or replace function lob_length(
  integer
) returns int4 as $$

declare
        id  alias for $1;
begin
        return sum(byte_len) from lob_data where lob_id = id;
end;$$ language plpgsql;