| 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: | Whole Thread | Raw Message | 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? |