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@recursor.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@falcon.sch.bme.hu Phone: +36-30-2699112