Postgres Pro
Downloads
Home   >   mailing lists

Re: cursors and function question - Mailing list pgsql-general

From David G. Johnston
Subject Re: cursors and function question
Date
Msg-id CAKFQuwb_H4jQvibPXKJJd_hFN-fzvgLd8+qjr9Q5xoo8vy_NZg@mail.gmail.com
Whole thread Raw
In response to Re: cursors and function question  (armand pirvu <armand.pirvu@gmail.com>)
List pgsql-general
Tree view
On Tue, Feb 13, 2018 at 12:03 PM, armand pirvu <armand.pirvu@gmail.com> wrote:

ERROR:  RETURN cannot have a parameter in function returning set
LINE 10:          return  var2;
HINT:  Use RETURN NEXT or RETURN QUERY.


and it just sits there

Any hints ?


https://www.postgresql.org/docs/10/static/plpgsql-control-structures.html#PLPGSQL-STATEMENTS-RETURNING​

David J.

pgsql-general by date:

Previous
From: armand pirvu
Date:
Subject: Re: cursors and function question
Next
From: Adrian Klaver
Date:
Subject: Re: pglogical in postgres 9.6