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(at)lfix(dot)co(dot)uk>
To: "John Brothers" <johnbr(at)undefined(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)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(dot)Elphick(at)lfix(dot)co(dot)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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly