From: | "Josh Berkus" <josh(at)agliodbs(dot)com> |
---|---|
To: | "Preeti Kamble" <preeti(dot)kamble(at)wipro(dot)com>, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Cursors in plpgsql |
Date: | 2001-04-17 14:56:12 |
Message-ID: | web-40638@davinci.ethosmedia.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
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 information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-04-17 15:04:39 | Re: failed sanity check, table answers was not found |
Previous Message | Rod Taylor | 2001-04-17 14:51:14 | Re: index not used with subselect in where clause ? |
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2001-04-17 15:08:09 | Re: Re: Using Random Sequence as Key |
Previous Message | Mark Stosberg | 2001-04-17 14:30:44 | function to format floats as money? |