SQL Dialects Reference/Write queries/Update returning

Update returning This variant of UPDATE statement allows to return the values from the row(s) affected by the update. No support in SQL:2003 UPDATE ... RETURNING ... INTO ... since 9.7. Only returns the updated values, see the documentation. UPDATE ... RETURNING ... since 2.1. Can return both old and new values using old. or new. prefixes but for at most one row, see the documentation. UPDATE ... OUTPUT ... since MS SQL Server 2005. Can return both old and new values using inserted. or deleted. prefixes, see the documentation. No support in 5.7. UPDATE ... RETURNING ... INTO ... Supports retrieving values of multiple rows with BULK COLLECT INTO, see the documentation. UPDATE ... RETURNING ... since 8.2. Only returns the updated values, see the documentation. No support in 3.8.