The following bug has been logged on the website: Bug reference: 7846 Logged by: Mike Sherrill Email address: m...@fontling.com PostgreSQL version: 9.1.6 Operating system: Ubuntu Linux 12.04 Description:
Documentation for the SQL UPDATE statement doesn't mention that it sets the FOUND variable. (Refer to sql-update.html, "Outputs".) That behavior *is* documented, but only in plpgsql-statements.html (Basic Statements, section 39.5.5). I understand the difference between a SQL statement and a PL/PGSQL statement. But if I were looking for the effects and side-effects of an UPDATE statement, I'd go to the docs for UPDATE, not for PL/PGSQL basic statements. I think that's what most people would do, especially if they didn't have prior knowledge of the FOUND variable. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs