Re: dblink inside plpgsql function

Loredana Curugiu wrote:
> I created the following function
>
> CREATE OR REPLACE FUNCTION getReminderServices( varchar ) RETURNS SETOF
> reminder_services AS'
> DECLARE r reminder_services%ROWTYPE;
> BEGIN
> SELECT dblink_connect(''dbname=''||$1);
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

> and I get the same errors. I think it is a problem with the dblink because
> the following function it works fine if I call SELECT * FROM
> getReminders().

You still haven't fixed the line above. The same rules apply to all SELECTs

--
Richard Huxton
Archonet Ltd