Re: getting oid of an INSERT automatically

Gee, you'd kinda think I could have read half-a-page down from where I had
been looking. I'm
an idiot.

Thanks,  John

----- Original Message -----
From: "Oliver Elphick" <olly@lfix.co.uk>
To: "John Brothers" <johnbr@undefined.com>
Cc: <pgsql-sql@postgresql.org>
Sent: Thursday, August 08, 2002 9:28 AM
Subject: Re: [SQL] getting oid of an INSERT automatically


> On Wed, 2002-08-07 at 19:39, John Brothers wrote:
> > Hello all,
> >
> >    In pgplsql, is there any way to get the oid that is returned from an
INSERT statement, without
> > doing a 'follow-up' SELECT for the oid?
>
> From the Programmers' Guide (PL/pgSQL section):
>
>     23.5.5. Obtaining result status
>
>     GET DIAGNOSTICS variable = item [ , ... ] ;
>
>     This command allows retrieval of system status indicators. Each item
>     is a keyword identifying a state value to be assigned to the
>     specified variable (which should be of the right data type to
>     receive it). The currently available status items are ROW_COUNT, the
>     number of rows processed by the last SQL query sent down to the SQL
>     engine; and RESULT_OID, the Oid of the last row inserted by the most
>     recent SQL query. Note that RESULT_OID is only useful after an
>     INSERT query.
>
> --
> Oliver Elphick                                Oliver.Elphick@lfix.co.uk
> Isle of Wight, UK
> http://www.lfix.co.uk/oliver
> GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
>                  ========================================
>      "Ye lust, and have not; ye kill, and desire to have,
>       and cannot obtain; ye fight and war, yet ye have not,
>       because ye ask not."            James 4:2
>
>
> ---------------------------(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