Received: from mail.india-today.com ([203.122.32.131])
	by postgresql.org (8.11.3/8.11.1) with SMTP id f3H6YJu09201
	for <pgsql-general@postgresql.org>;
	Tue, 17 Apr 2001 02:34:20 -0400 (EDT)
	(envelope-from anand@mail.india-today.com)
Received: (qmail 14580 invoked by uid 500); 17 Apr 2001 06:34:14 -0000
Date: Tue, 17 Apr 2001 12:04:14 +0530
From: Anand Raman <araman@india-today.com>
To: pgsql-general@postgresql.org
Subject: Re: Cursors in plpgsql
Message-ID: <20010417120414.I31344@india-today.com>
Mail-Followup-To: pgsql-general@postgresql.org
References: <3ADAF57B.2FD493FC@wipro.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.2.5i
In-Reply-To: <3ADAF57B.2FD493FC@wipro.com>;
	from preeti.kamble@wipro.com on Mon, Apr 16, 2001 at 07:06:59PM
	+0530
75Uptime: 3:30pm  up 3 days, 22 min, 19 users, load average: 0.16, 0.14, 0.07
X-Archive-Number: 200104/672
X-Sequence-Number: 7832

there is the FOUND variable which can be negated to have the desired
effect ..

Try out 

IF NOT FOUND ....

Hope this helps
Anand
On Mon, Apr 16, 2001 at 07:06:59PM +0530, Preeti Kamble wrote:
>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
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster