[GENERAL] Question in dblink

From: Abraham, Danny <danny_abraham(at)bmc.com>
Date: Thu Dec 06 2007 - 10:29:20 EST

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

---------------------------(end of broadcast)---------------------------

TIP 2: Don't 'kill -9' the postmaster Received on Thu Dec 6 10:39:52 2007