Re: "returning" in postgresql request

GIROIRE, Nicolas (COFRAMI) wrote:
> Hi,
>
> I try to deploy an Application with Oracle Database to a solution
> with postgresql. the Oracle system exists and we use a request which
> return an int in a variable nb by "returning nb_lock into nb"
>
> UPDATE xdb_ancestors_lock SET nb_lock=nb_lock+1 WHERE doc_id=? AND
> ele_id=? returning nb_lock INTO nb;
>
> I'd like to know if there is equivalent solution under postgresql or
> if i'm obliged to do a select before my update.

I think something similar has been discussed, but there's nothing like
it at the moment. You'll have to SELECT FOR UPDATE; UPDATE

--
Richard Huxton
Archonet Ltd