Re: Cursors in plpgsql

Preeti,

> Is there a command in plpgsql similar to  %NOTFOUND of oracle?

Cursors are not currently supported for PL/pgSQL.  There are plans to
include them for and upcoming version of Postgres.  But dont' wait your
application on it.

> 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???

Yes.  Please see my post from last week called: "Re: [SQL] Calling plSQL
functions".

-Josh Berkus

______AGLIO DATABASE SOLUTIONS___________________________                                      Josh Berkus Complete
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco