Thread: PL/pgSQL bug: FOUND variable is not updated correct with EXECUTE

Doing an EXECUTE for a query which returns results still yields 'f'
for the FOUND variable. "GET DIAGNOSTICS" on the other hand, works
fine,

Using version 8 on Win32.

--
 ICQ: 1912453
 AIM: VitalyB1984
 MSN: tmdagent@hotmail.com
 Yahoo!: VitalyBe

Vitaly Belman <vitalyb@gmail.com> writes:
> Doing an EXECUTE for a query which returns results still yields 'f'
> for the FOUND variable.

This is not a bug.  Read the list of statements that update FOUND.
EXECUTE is not one of them.

            regards, tom lane

On Tue, 2005-02-08 at 18:11 -0500, Tom Lane wrote:
> Vitaly Belman <vitalyb@gmail.com> writes:
> > Doing an EXECUTE for a query which returns results still yields 'f'
> > for the FOUND variable.
>
> This is not a bug.  Read the list of statements that update FOUND.
> EXECUTE is not one of them.

See also previous discussion on this topic:

    http://archives.postgresql.org/pgsql-bugs/2004-10/msg00001.php

-Neil