Received: from mail.fastlane.com.br (mail.fastlane.com.br [200.215.30.6] (may be forged)) by hub.org (8.10.1/8.11.0) with SMTP id e9HABbW67851 for ; Tue, 17 Oct 2000 06:11:37 -0400 (EDT) (envelope-from eduardo@brasilnet.net) Received: (qmail 24190 invoked from network); 17 Oct 2000 09:13:35 -0000 Received: from complex.funcitec.rct-sc.br (HELO YOSEMITE) (200.135.30.171) by fastlane.com.br with SMTP; 17 Oct 2000 09:13:35 -0000 From: Eduardo To: pgsql-sql@postgresql.org Subject: Last serial number inserted Date: Tue, 17 Oct 2000 08:16:58 -0200 X-Mailer: KMail [version 1.0.29] Content-Type: text/plain MIME-Version: 1.0 Message-Id: <00101708182600.00842@YOSEMITE> Content-Transfer-Encoding: 8bit X-Archive-Number: 200010/153 X-Sequence-Number: 1815 How can I get the last id ( serial number ) inserted. My C code is : res = PQexec(conn,"insert into table1 (field1) values ('value1')"); table1: id SERIAL, field1 VARCHAR(10) Thanks Eduardo K