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