lld_copy_subset 例程

图: lld_copy_subset 例程

-- Using the lld_copy_subset function

create function lld_copy_subset (lld_locator, lld_locator, int8, int)
        returns lld_locator
        external name '/tmp/sapidemo.so'
        language c;

insert into lobs
        values (5, lld_copy_subset (
                "row('ifx_file',null,'/tmp/quote3.txt')"::lld_locator,
        "row('ifx_clob',null,null)"::lld_locator, 20, 70));

select lo from lobs where key = 5;
select lo.lo_pointer::clob from lobs where key = 5;