X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6AB1C8B9DFE for ; Thu, 3 Feb 2005 22:07:59 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 04748-04 for ; Thu, 3 Feb 2005 22:07:48 +0000 (GMT) Received: from screen.dri.edu (screen.dri.edu [134.197.100.251]) by svr1.postgresql.org (Postfix) with ESMTP id ED2A78B9E3E for ; Thu, 3 Feb 2005 22:07:48 +0000 (GMT) Received: (from fw_mx@localhost) by screen.dri.edu (8.9.1b+Sun/8.9.1) id OAA10906 for ; Thu, 3 Feb 2005 14:07:47 -0800 (PST) Received: from derringer.dri.edu( 10.10.9.111) by screen.dri.edu via smap (V2.1.dri) id xma010871; Thu, 3 Feb 05 14:07:31 -0800 Received: from dri.edu (ppp06.dri.edu [10.10.8.206]) by derringer.dri.edu (8.9.3+Sun/8.9.1) with ESMTP id OAA22353 for ; Thu, 3 Feb 2005 14:07:30 -0800 (PST) Message-ID: <4202A2A3.7070707@dri.edu> Date: Thu, 03 Feb 2005 14:16:03 -0800 From: lorid User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7a) Gecko/20040219 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: getting back autonumber just inserted References: <5d14ecf90410162019443dc355@mail.gmail.com> In-Reply-To: <5d14ecf90410162019443dc355@mail.gmail.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200502/79 X-Sequence-Number: 20190 I could have sworn I kept a copy of prior emails that discussed how to get back a value that was just inserted into a autonumber (or in postgresql case a sequence number) any help will be appreciated thanks Lori