[SQL] dblink inside plpgsql function

[Loredana Curugiu]

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