Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id ABAB29FB612 for ; Tue, 13 Mar 2007 10:33:47 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 14482-02 for ; Tue, 13 Mar 2007 10:33:27 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from correio2.docasdoporto.com.br (8.144.199.200.docasdoporto.com.br [200.199.144.8]) by postgresql.org (Postfix) with ESMTP id C78D79FB734 for ; Tue, 13 Mar 2007 10:33:27 -0300 (ADT) Received: from [201.30.172.2] (account ezequias@fastcon.com.br HELO [192.168.0.110]) by correio2.docasdoporto.com.br (CommuniGate Pro SMTP 4.1.8) with ESMTP id 46356543 for pgsql-sql@postgresql.org; Tue, 13 Mar 2007 10:50:28 -0300 Message-ID: <45F6A793.1090904@fastcon.com.br> Date: Tue, 13 Mar 2007 10:30:59 -0300 From: "Ezequias R. da Rocha" User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re: For loop References: <45F69D7C.4070304@fastcon.com.br><45F6A06E.7090104@fastcon.com.b r><45F6B1A2.A3DD.0030.0@indicator.be><45F6B1A2.A3DD.0030.0@indicator.be>< 45F6A4E5.7090707@fastcon.com.br> <45F6B4EB.A3DD.0030.0@indicator.be> In-Reply-To: <45F6B4EB.A3DD.0030.0@indicator.be> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/159 X-Sequence-Number: 27797 I quetion one more time. I must have a function ? Isn't another way to implement it without using functions ? Ezequias Bart Degryse escreveu: > Please post your complete CREATE FUNCTION statement. Error code 42601 > refers to some syntax error which probably occurs just before you > start looping. To find it I need to see more code. > Please don't mail me directly. Only mail to pgsql-sql@postgresql.org > > > >>> "Ezequias R. da Rocha" 2007-03-13 14:19 >>> > They are not working well. > > Allways the same error. > > (if while) > ERROR: syntax error at or near "WHILE" > SQL state: 42601 > Character: 1 > > (if for) > > ERROR: syntax error at or near "FOR" > SQL state: 42601 > Character: 1 > > (if loop) > ERROR: syntax error at or near "LOOP" > SQL state: 42601 > Character: 1 > I installed the pgsql but I don't think it is a problem of language. > What could be wrong ? I am not using functions too. I am using the SQL > tool of PgAdmin III. > > Any help would be glad. > > Ezequias > > Bart Degryse escreveu: > > As you can see in the manual > > > (http://www.postgresql.org/docs/8.1/interactive/plpgsql-control-structures.html) > > > you have to remove the ; after the initial LOOP > > > > LOOP > > statements > > IF i > 1000000 THEN EXIT; > > END LOOP; > > > > Or you can try... > > > > WHILE i <= 1000000 LOOP > > statements > > END LOOP; > > > > Or even... (don't initialize i in this case) > > > > FOR i IN 1 .. 1000000 LOOP > > statements > > END LOOP; > > > > >>> "Ezequias R. da Rocha" 2007-03-13 > 14:00 >>> > > Ezequias R. da Rocha escreveu: > > > Hi list, > > > > > > I would like to test the power of processing of postgresql (and my > > > server) by insert a large ammount of data on a table I have. > > > > > > I would like to know how to implement a For... loop . With it I think > > > I could check the real power of my server. > > > > > > Ezequias > > > > > I tryed a way but it is not working. Please see it: > > > > LOOP; > > -- some computations > > insert into carga (desc) values ('My Text'); > > IF count > 1000000 THEN > > EXIT; -- exit loop > > END IF; > > END LOOP; > > > > The postgresql reports the following error: > > / > > ERROR: syntax error at or near "LOOP" > > SQL state: 42601 > > Character: 1/ > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 3: Have you checked our extensive FAQ? > > > > http://www.postgresql.org/docs/faq >