Обсуждение: Question in dblink

Поиск
Список
Период
Сортировка

Question in dblink

От
"Abraham, Danny"
Дата:
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