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
>
> On Tue, 8 Oct 2002, Jean-Luc Lachance wrote:
>
> > You want OID as in:
> >
> > Select OID, * from table;
>
> ___________________________________________________________________________
> Nagy Zoltan iloz@falcon.sch.bme.hu Phone: +36-30-2699112
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly