Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f3H52du62291 for ; Tue, 17 Apr 2001 01:02:39 -0400 (EDT) (envelope-from pgsql-general-owner@postgresql.org) Received: from wiprom2mx1.wipro.com (wiprom2mx1.wipro.com [203.197.164.41]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f3GDVFu20179; Mon, 16 Apr 2001 09:31:16 -0400 (EDT) (envelope-from preeti.kamble@wipro.com) Received: from m2hub.mail.wipro.com (m2hub.wipro.com [164.164.27.50]) by wiprom2mx1.wipro.com (8.9.3+Sun/8.9.3) with ESMTP id TAA03247; Mon, 16 Apr 2001 19:09:19 GMT Received: from m2vwall2.wipro.com ([164.164.27.52]) by m2hub.mail.wipro.com (Netscape Messaging Server 4.15) with SMTP id GBW00500.2UH; Mon, 16 Apr 2001 18:56:29 +0530 Received: from wipro.com ([192.168.168.223]) by lvlmail.mail.wipro.com (Netscape Messaging Server 4.15) with ESMTP id GBW0KO00.GVH; Mon, 16 Apr 2001 19:08:48 +0530 Message-ID: <3ADAF57B.2FD493FC@wipro.com> Date: Mon, 16 Apr 2001 19:06:59 +0530 From: "Preeti Kamble" X-Mailer: Mozilla 4.6 [en] (WinNT; I) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org, pgsql-general@postgresql.org Subject: Cursors in plpgsql Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200104/668 X-Sequence-Number: 7823 Hi Is there a command in plpgsql similar to %NOTFOUND of oracle? i want to write a load script which takes each row from the temporary table, do some processing and insert into actual tables. Any idea how i can accomplish this??? thank you regards Preeti