Re: [GENERAL] "returning" in postgresql request

2005-06-09 Thread Matt Miller
> > deploy an Application with Oracle Database to a solution with postgresql. > > ... > > UPDATE xdb_ancestors_lock SET nb_lock=nb_lock+1 WHERE doc_id=? AND > > > ele_id=? returning nb_lock INTO nb; > Looks like you really want: > > UPDATE xdb_ancestors_lock SET nb_lock=nextval('nb_lock_sequence'

Re: [GENERAL] "returning" in postgresql request

2005-06-09 Thread Tino Wildenhain
Am Donnerstag, den 09.06.2005, 16:30 +0200 schrieb GIROIRE, Nicolas (COFRAMI): > 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_

Re: [GENERAL] "returning" in postgresql request

2005-06-09 Thread Richard Huxton
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

[GENERAL] "returning" in postgresql request

2005-06-09 Thread GIROIRE, Nicolas (COFRAMI)
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=?