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
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
