Re: ROWID ? or other internal ID

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