| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | "Ezequias R(dot) da Rocha" <ezequias(at)fastcon(dot)com(dot)br> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: For loop |
| Date: | 2007-03-13 13:40:41 |
| Message-ID: | 20070313134041.GB6715@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Ezequias R. da Rocha wrote:
> I quetion one more time. I must have a function ? Isn't another way to
> implement it without using functions ?
The syntax you show is plpgsql. You cannot use that without a function.
(The alternative would be to script the bulk insertion client-side,
which I'd think is smarter anyway).
If what you need to do is batch processing of rows to produce other
rows, then maybe you can craft an INSERT .. SELECT query to do it
instead of this row-at-a-time approach.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bart Degryse | 2007-03-13 13:41:13 | Re: For loop |
| Previous Message | Jonah H. Harris | 2007-03-13 13:39:27 | Re: For loop |