I think ROWID in oracle is global abstract identifier for the row not
necessarily sequential.
Identity columns as I understand are autoincrementing, per table. The
oracle equivalent would be using an insert trigger getting values from a
sequence (a much better solution IMHO than identity columns)
david jencks
On 2001.07.26 12:00:02 -0400 Reynir Hübner wrote:
> 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
>
>
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
