Skip site navigation (1) Skip section navigation (2)

Re: ROWID ? or other internal ID

From: iloz(at)recursor(dot)hu
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: ROWID ? or other internal ID
Date: 2002-10-10 08:08:38
Message-ID: Pine.LNX.4.21.0210101008130.15201-100000@www.recursor.com (view raw or flat)
Thread:
Lists: pgsql-odbc
Ok, but how can I use this with ODBC?

On Wed, 9 Oct 2002, Jean-Luc Lachance wrote:

> In PL/pgSQL you can :
> 
> GET DIAGNOSTICS {variable} = RESULT_OID;
> 
> to get the OID of the previous INSERTed, DELETEd or UPDATEd row.
> 
> JLL
> 
> 
> iloz(at)recursor(dot)hu wrote:
> > 
> > Hi!
> > 
> > I'm new in postgresql-ODBC but not in postgresql. I use it with PHP long
> > time ago.
> > I use OID for selecting and also for referencing rows. For this I need to
> > know the OID of the last inserted row. In php I have getlastoid function
> > for this.
> > I tried "insert" then "select :LASTOID" with ODBC but it has returned with
> > error. (I tried it in the same connection)
> > How can I get the OID of last inserted row with ODBC?
> > 
> > Thanks
> > Zoltan

___________________________________________________________________________
    Nagy Zoltan      iloz(at)falcon(dot)sch(dot)bme(dot)hu      Phone: +36-30-2699112



Responses

pgsql-odbc by date

Next:From: mhepwortDate: 2002-10-10 14:53:13
Subject: pgAdmin2 and the ODBC driver for postgresql
Previous:From: Jean-Luc LachanceDate: 2002-10-09 15:29:16
Subject: Re: ROWID ? or other internal ID

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group