PL/PgSQL: stmt_fors and variable value after loop

From: Marko Tiikkaja <marko(at)joh(dot)to>
To: PG Docs <pgsql-docs(at)postgresql(dot)org>
Subject: PL/PgSQL: stmt_fors and variable value after loop
Date: 2015-01-19 15:37:37
Message-ID: 54BD24C1.4060601@joh.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

Hi,

As far as I can tell, according to the documentation[1] the return value
of this PL/PgSQL function is undefined:

CREATE OR REPLACE FUNCTION public.foof()
RETURNS integer
LANGUAGE plpgsql
AS $function$
declare
_f1 int;
begin
for _f1 in select 1 loop
end loop;
return _f1;
end
$function$

But at least based on my understanding of exec_for_query() in pl_exec.c,
a FOR loop over query results will always terminate with the values from
the last row if at least one was found, regardless of whether EXIT was
used or not. Is there a reason this detail has been left undefined in
the documentation? If not, can we change the documentation?

.marko

[1]:
http://www.postgresql.org/docs/9.4/static/plpgsql-control-structures.html#PLPGSQL-RECORDS-ITERATING

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Tom Lane 2015-01-19 15:44:06 Re: PL/PgSQL: stmt_fors and variable value after loop
Previous Message David Johnston 2015-01-17 06:08:10 Suggest adding reference to pg_db_role_setting in chapter 18; expand catalog page