Received: from news.tht.net (news.hub.org [216.126.91.242]) by hub.org (8.10.1/8.10.1) with ESMTP id e5CNfrT58640 for ; Mon, 12 Jun 2000 19:41:53 -0400 (EDT) Received: (from news@localhost) by news.tht.net (8.9.3/8.9.3) id TAA62221 for pgsql-sql@postgresql.org; Mon, 12 Jun 2000 19:41:22 -0400 (EDT) (envelope-from news) X-Authentication-Warning: news.tht.net: news set sender to using -f From: Alex X-Newsgroups: linux.postgres, comp.databases.postgresql.questions, comp.databases.postgresql.sql Subject: Simple search question Date: Tue, 13 Jun 2000 09:42:01 +1000 Organization: billgates.org - opensource Win3.1 project Lines: 10 Message-ID: <39457549.CEA07C63@ihug.com.au> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Server-Date: 12 Jun 2000 23:41:13 GMT X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.12-20 i686) X-Accept-Language: en To: pgsql-sql@postgresql.org X-Archive-Number: 200006/128 Hi, after running a script which performs an insert, a new tuple is created, and a serial number is generated for it. I want to write the new tuple data back to the screen, including the new serial number. My question is, do I have to do a search for the tuple just inserted in order to get the data back again? I am thinking there must be a faster, more efficient way. Thanks, Alex