From: John Brothers <johnbr@undefined.com>
To: Oliver Elphick <olly@lfix.co.uk>
Cc: pgsql-sql@postgresql.org
Subject: Re: getting oid of an INSERT automatically
Date: Thu, 8 Aug 2002 15:18:57 -0400
Message-ID: <00a801c23f10$721cec80$0c05050a@johnbr> (raw)
References: <00fe01c23e41$ca62bca0$0c05050a@johnbr>
<1028813335.31323.50.camel@linda>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: johnbr@undefined.com, olly@lfix.co.uk
Subject: Re: getting oid of an INSERT automatically
In-Reply-To: <00a801c23f10$721cec80$0c05050a@johnbr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox