Re: dblink inside plpgsql function - Mailing list pgsql-sql

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