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. ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
