X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 813A05286E for ; Tue, 16 Aug 2005 18:10:00 -0300 (ADT) 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 04960-01 for ; Tue, 16 Aug 2005 21:09:55 +0000 (GMT) Received: from mail.segrestfarms.com (unknown [65.124.195.241]) by svr1.postgresql.org (Postfix) with SMTP id 3C81252AEC for ; Tue, 16 Aug 2005 18:09:53 -0300 (ADT) Received: (qmail 19305 invoked by uid 399); 16 Aug 2005 21:07:49 -0000 Received: from unknown (HELO njord.segrestfarms.com) (65.124.195.227) by 65-124-195-241.dia.cust.qwest.net with SMTP; 16 Aug 2005 21:07:49 -0000 Received: from [192.100.100.176] (unknown [192.100.100.176]) by njord.segrestfarms.com (Postfix) with ESMTP id 7998280E524 for ; Tue, 16 Aug 2005 22:34:06 -0400 (EDT) Message-ID: <430255F0.7060500@segrestfarms.com> Date: Tue, 16 Aug 2005 17:09:04 -0400 From: "josh@segrestfarms.com" User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: SQL Help - Obtaining ID of record INSERTED Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.802 required=5 tests=[AWL=-0.013, FORGED_RCVD_HELO=0.05, RCVD_IN_DSBL=2.765] X-Spam-Level: ** X-Archive-Number: 200508/197 X-Sequence-Number: 18516 Greetings. INSERT INTO orderstemp (customerid,datecreated) VALUES ('5443','8/16/2005 12:00PM') The table orderstemp has a unique identifier field, orderid (of type SERIAL). How can I obtain the orderid of the record inserted in the INSERT INTO statement in postgresql? MSSQL does it like this: INSERT INTO orderstemp (customerid,datecreated) VALUES ('5443','8/16/2005 12:00PM') SELECT @@identity as orderid but this doens't work in postgresql. Any ideas? Thanks in advance.