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
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings