Re: BUG #13967: Documentation. Plpgsql 'execute' description

On Wed, Feb 17, 2016 at 8:11 AM, <iurii(dot)i(dot)popov(at)gmail(dot)com> wrote:

> The following bug has been logged on the website:
>
> Bug reference: 13967
> Logged by: Iurii Popov
> Email address: iurii(dot)i(dot)popov(at)gmail(dot)com
> PostgreSQL version: 9.5.1
> Operating system: Ubuntu
> Description:
>
> At
>
> http://www.postgresql.org/docs/9.5/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN
>
> you can see
>
> If multiple rows are returned, only the first will be assigned to the INTO
> variable.
>
> It will be useful to write information from (or a link to)
>
> http://www.postgresql.org/docs/9.5/static/plpgsql-control-structures.html#AEN62513
>
> about RETURN QUERY EXECUTE statement to return set of rows.
>

The former (returning a value into a internally defined variable) is
separate from the second (returning a value to outside ​the function).
While they do have some relation to each other - namely the former can be
used to set variables that are then externally returned - that seems
insufficient.

But, maybe I'm too familiar with this. Maybe a more detailed suggestion
would make the need more clear.

In any case this seems to be quite far from being a bug. There is a
pgsql-docs list where suggestions like this are better posted.

David J.