Re: ROWID ? or other internal ID

Just create a stored procedure that returns RESULT_OID;

iloz(at)recursor(dot)hu wrote:
>
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org