From: Loredana Curugiu <loredana.curugiu@gmail.com>
To: pgsql-novice@postgresql.org
To: pgsql-sql@postgresql.org
Subject: dblink inside plpgsql function
Date: Tue, 3 Jul 2007 12:02:54 +0300
Message-ID: <1c23c8e70707030202n323ee171n20f39cdece5b3618@mail.gmail.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: loredana.curugiu@gmail.com, pgsql-novice@postgresql.org
Subject: Re: dblink inside plpgsql function
In-Reply-To: <1c23c8e70707030202n323ee171n20f39cdece5b3618@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox