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
