dblink inside plpgsql function

Поиск
Список
Период
Сортировка
От Loredana Curugiu
Тема dblink inside plpgsql function
Дата
Msg-id 1c23c8e70707030202n323ee171n20f39cdece5b3618@mail.gmail.com
обсуждение исходный текст
Ответы Re: dblink inside plpgsql function  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Список pgsql-sql
Hi everybody,

I created the following function:

CREATE OR REPLACE FUNCTION GetReminderServices( varchar ) RETURNS SETOF reminder_services AS'
BEGIN
    SELECT dblink_connect(''dbname=''||$1);
    SELECT * FROM dblink(''SELECT * FROM reminder_services'')
               AS reminder_services( uid INT,
                                     theme_uid INT,
                                     activity_MT_amount INT,
                                     activity_min_days INT,
                                     activity_max_months INT,
                                     inactivity_days INT,
                                     limit_reminders INT,
                                     limit_months INT,
                                     scanning_time TIMESTAMP WITH TIME ZONE,
                                     reminder_time TIMESTAMP WITH TIME ZONE,
                                     message TEXT);
    SELECT dblink_disconnect($1);
    RETURN; 
END;
' LANGUAGE plpgsql;

When I call this function as SELECT * FROM GetReminderServices('eu');
I get the following errors:
ERROR:  query has no destination for result data
HINT:  If you want to discard the results of a SELECT, use PERFORM instead.
CONTEXT:  PL/pgSQL function "getreminderservices" line 2 at SQL statement

Does somebody know which is the problem?


Best,
     Loredana



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

Предыдущее
От: Michael Glaesemann
Дата:
Сообщение: Re: Using escape strings in an insert statement.
Следующее
От: "Pavel Stehule"
Дата:
Сообщение: Re: dblink inside plpgsql function