Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id BC6A4475C06 for ; Thu, 8 Aug 2002 09:28:54 -0400 (EDT) Received: from anchor-post-35.mail.demon.net (anchor-post-35.mail.demon.net [194.217.242.85]) by postgresql.org (Postfix) with ESMTP id 1852C475BEE for ; Thu, 8 Aug 2002 09:28:54 -0400 (EDT) Received: from lfix.demon.co.uk ([158.152.59.127] helo=linda.lfix.co.uk) by anchor-post-35.mail.demon.net with esmtp (Exim 3.36 #2) id 17cnLU-00033j-0U; Thu, 08 Aug 2002 14:28:56 +0100 Received: from localhost ([127.0.0.1] helo=localhost.localdomain ident=olly) by linda.lfix.co.uk with esmtp (Exim 3.35 #1 (Debian)) id 17cnLT-0004uw-00; Thu, 08 Aug 2002 14:28:55 +0100 Subject: Re: getting oid of an INSERT automatically From: Oliver Elphick To: John Brothers Cc: pgsql-sql@postgresql.org In-Reply-To: <00fe01c23e41$ca62bca0$0c05050a@johnbr> References: <00fe01c23e41$ca62bca0$0c05050a@johnbr> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.7 Date: 08 Aug 2002 14:28:54 +0100 Message-Id: <1028813335.31323.50.camel@linda> Mime-Version: 1.0 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/151 X-Sequence-Number: 8997 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?