PL/pgSQL: FOUND not set by EXECUTE? - Mailing list pgsql-general

From Brendan Jurd
Subject PL/pgSQL: FOUND not set by EXECUTE?
Date
Msg-id 40B1C68C.6040700@blakjak.sytes.net
Whole thread Raw
Responses Re: PL/pgSQL: FOUND not set by EXECUTE?
List pgsql-general
Hello all,

I've discovered that in 7.4.2 PL/pgSQL, the FOUND variable is not at all
affected by use of the EXECUTE command, even if the statement you pass
to EXECUTE would set FOUND to true when run directly.  The documentation
doesn't really point this out, and in my opinion, it's an unintuitive
behaviour.  Why would executing the command dynamically make a
difference to how FOUND is treated?  The statement still "happens" in
the end, additional query plan or no.

Could someone please clarify?

Regards,

Brendan Jurd



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: dump / restore questions
Next
From: Matthias Nagl
Date:
Subject: Combining several rows