</para>

<para>

Previously RETURNING only returned new values for INSERT and UPDATE, old values for DELETE; MERGE would return the appropriate value for the internal query executed. This new syntax

allowsINSERT with an ON CONFLICT action to return old values,UPDATE to return oldvalues,andDELETE to returnnew valuesifthequery assigned to an ON DELETE row would return new

values. New syntax allows changeable relation aliases "old" and "new" to specify which values should be returned.

Previously RETURNING only returned new values for INSERT and UPDATE,andold values for DELETE; MERGE would return the appropriate value for the internal query executed. This new syntax

allowsthe RETURNING list of INSERT/UPDATE/DELETE/MERGE toexplicitlyreturn old and new valuesby usingthespecial aliases "old" and "new". These aliases can be renamed to

avoid identifier conflicts.

</para>

</listitem>