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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-odbc by date

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