the equvaliant to @@identity in ORacle is called ROWID. 
It is propriatary for each db server. 

I dont know how it is in postgreSQL.
-r



-----Original Message-----
From: Maraya Michael [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 26, 2001 3:50 PM
To: '[EMAIL PROTECTED]'
Subject: RE: [JBoss-user] Auto Incrementing Primary Key with PostgreSQL
and JBoss



        I don't use Postgres but on MS SQL Server, I call "SELECT
@@IDENTITY" immediately after the insert statement.  Perhaps this will
lead
you in the right direction.

---
Michael R. Maraya


> ----------
> From:         Federico Vesco[SMTP:[EMAIL PROTECTED]]
> Reply To:     [EMAIL PROTECTED]
> Sent:         Thursday, July 26, 2001 11:06 AM
> To:   [EMAIL PROTECTED]
> Subject:      [JBoss-user] Auto Incrementing  Primary Key with
PostgreSQL
> and JBoss
> 
> 
> How may  i obtain the value of the primary key generated by PostgreSQL
( i
> 
> need to obtain this value because i have to return the primary key
value)
> ? 
> I thougth I migth obtain it with a simple select query, but in this
way
> i'm 
> not sure the value I obtain is exactly the one needed (by definition,
only
> 
> the primary key identifies univokely a record).
> Any suggestion? How can i manage this situation? Do you think I have
do 
> change my program?
> 
> 

_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to