UPDATE...RETURNING col INTO var - what is returned? - Mailing list pgsql-general

From Rainer Pruy
Subject UPDATE...RETURNING col INTO var - what is returned?
Date
Msg-id 4BFE99F7.9030207@acrys.com
Whole thread Raw
Responses Re: UPDATE...RETURNING col INTO var - what is returned?  (Alban Hertroys <dalroi@solfertje.student.utwente.nl>)
List pgsql-general
Hi all,
I just got quite confused on the exact semantics
of "RETURNING expressions INTO target" with an update statement.

And while trying to resolve failed to find an answer in the  docs.

Question was whether - in case "expression" is involving a column that is assigned by the update itself -
the value returned is based on the "old" value or the "new" value".

While I'm no back to assuming is has to be the "old" one,
I did not find a reference to that fact with the docs.

Where should I have looked?
Or is it actually missing?
Then, could one add this, e.g. to the description of RETURNING .. INTO (Executing a query with a single row result)
just for clarification, to dispel doubts.


Thanks
Rainer

pgsql-general by date:

Previous
From: Tim Landscheidt
Date:
Subject: Re: Please help me write a query
Next
From: Alban Hertroys
Date:
Subject: Re: UPDATE...RETURNING col INTO var - what is returned?