How to use dblink within pl/pgsql function:

Поиск
Список
Период
Сортировка
От Clive Page
Тема How to use dblink within pl/pgsql function:
Дата
Msg-id Pine.LNX.4.44L0.0311030956200.29653-100000@peneca.star.le.ac.uk
обсуждение исходный текст
Ответы Re: How to use dblink within pl/pgsql function:  (Joe Conway <mail@joeconway.com>)
Список pgsql-general
What I'd like to do is use dblink to extract a few rows from a remote
database and manipulate these within a function in pl/pgsql.  Something
like this:

CREATE OR REPLACE FUNCTION find() RETURNS INTEGER AS '
  DECLARE
    count INTEGER:
    myrec RECORD;
  BEGIN
  FOR myrec IN SELECT * FROM DBLINK(''select x,y from mytab'') as
     temp(x integer, y real) LOOP
     count := count + 1;
  END LOOP;
  RETURN count;
END; ' LANGUAGE 'plpgsql';


But this syntax does not work, and I cannot find a form which does work.
Does anyone know how to do this?

Thanks in advance.

--
Clive Page


В списке pgsql-general по дате отправления:

Предыдущее
От: "Russell Crosser"
Дата:
Сообщение: Internet based database
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: slow down on UPDATE using IN statements