I would like the code below to accept the returned value from t2.
How do I do it?
Thanks
Danny
=======================================================
err := dblink_connect('C',cname);
begin
execute dblink('C','SELECT t2()');
exception
when others then null;
end;
err := dblink_disconnect('C');
======================================================
CREATE OR REPLACE FUNCTION t2() RETURNS integer
AS
$$
DECLARE
i integer;
BEGIN
execute 'insert into x values(12)';
return 67;
END;
$$ LANGUAGE 'plpgsql' VOLATILE;
======================================================
Danny Abraham
BMC Software
CTM&D Business Unit
972-52-4286-513
danny_abraham@bmc.com