Re: improve FOUND in PL/PgSQL - Mailing list pgsql-patches

From Tom Lane
Subject Re: improve FOUND in PL/PgSQL
Date
Msg-id 17576.1029368156@sss.pgh.pa.us
Whole thread Raw
In response to Re: improve FOUND in PL/PgSQL  (Neil Conway <nconway@klamath.dyndns.org>)
Responses Re: improve FOUND in PL/PgSQL  (Neil Conway <nconway@klamath.dyndns.org>)
List pgsql-patches
Neil Conway <nconway@klamath.dyndns.org> writes:
>> This is better than what we had, but still seems confusing

> Ok, I made this part of the documentation more clear.

BTW, the text still fails to make it clear that the statements will in
fact reset FOUND to false when they process zero rows (or whatever).
One could easily read this text as saying that FOUND will be the logical
OR of whether all the statements-so-far found a row.

It might also be good to spell out that FOUND is local in each plpgsql
function, not a global variable.

            regards, tom lane

pgsql-patches by date:

Previous
From: Neil Conway
Date:
Subject: Re: improve FOUND in PL/PgSQL
Next
From: Neil Conway
Date:
Subject: Re: improve FOUND in PL/PgSQL