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

Re: ROWID ? or other internal ID

From: Jean-Luc Lachance <jllachan(at)nsd(dot)ca>
To: iloz(at)recursor(dot)hu
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: ROWID ? or other internal ID
Date: 2002-10-09 15:29:16
Message-ID: 3DA44B4C.3BCACBB7@nsd.ca (view raw or flat)
Thread:
Lists: pgsql-odbc
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
> 
> On Tue, 8 Oct 2002, Jean-Luc Lachance wrote:
> 
> > You want OID as in:
> >
> > Select OID, * from table;
> 
> ___________________________________________________________________________
>     Nagy Zoltan      iloz(at)falcon(dot)sch(dot)bme(dot)hu      Phone: +36-30-2699112
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

In response to

pgsql-odbc by date

Next:From: ilozDate: 2002-10-10 08:08:38
Subject: Re: ROWID ? or other internal ID
Previous:From: ilozDate: 2002-10-09 09:35:52
Subject: Re: ROWID ? or other internal ID

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