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-09 09:35:52
Message-ID: Pine.LNX.4.21.0210091135330.21391-100000@www.recursor.com (view raw or flat)
Thread:
Lists: pgsql-odbc
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


Responses

pgsql-odbc by date

Next:From: Jean-Luc LachanceDate: 2002-10-09 15:29:16
Subject: Re: ROWID ? or other internal ID
Previous:From: Tom LaneDate: 2002-10-09 04:55:53
Subject: Re: ROWID ? or other internal ID

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