Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id AD3129FB31E for ; Tue, 13 Mar 2007 10:14:11 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 32393-02 for ; Tue, 13 Mar 2007 10:14:02 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from interscan.indicator.com (mail.indicator.be [193.121.199.3]) by postgresql.org (Postfix) with ESMTP id 11CD79FB2C8 for ; Tue, 13 Mar 2007 10:14:06 -0300 (ADT) Received: from webaccess.indicator.be ([10.100.1.7]) by interscan.indicator.com with InterScan Message Security Suite; Tue, 13 Mar 2007 14:01:20 +0100 Received: from DOMEXT-MTA by webaccess.indicator.bewith Novell_GroupWise; Tue, 13 Mar 2007 14:14:04 +0100 Message-Id: <45F6B1A2.A3DD.0030.0@indicator.be> X-Mailer: Novell GroupWise Internet Agent 7.0.1 Date: Tue, 13 Mar 2007 14:13:55 +0100 From: "Bart Degryse" To: Cc: "Ezequias R. da Rocha" Subject: Re: For loop References: <45F69D7C.4070304@fastcon.com.br><45F6A06E.7090104@fastcon.com.b r> In-Reply-To: <45F6A06E.7090104@fastcon.com.br> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=__PartFBDF4583.1__=" X-imss-version: 2.046 X-imss-result: Passed X-imss-approveListMatch: *@indicator.be X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.45 tagged_above=0 required=5 tests=AWL, BAYES_40, FORGED_RCVD_HELO, HTML_40_50, HTML_MESSAGE, UNPARSEABLE_RELAY X-Spam-Level: X-Archive-Number: 200703/154 X-Sequence-Number: 27792 --=__PartFBDF4583.1__= Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable As you can see in the manual (http://www.postgresql.org/docs/8.1/interactiv= e/plpgsql-control-structures.html) you have to remove the ; after the = initial LOOP =20 LOOP statements IF i > 1000000 THEN EXIT; END LOOP; =20 Or you can try... =20 WHILE i <=3D 1000000 LOOP statements END LOOP; =20 Or even... (don't initialize i in this case) =20 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=20 > 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=20 > 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 --=__PartFBDF4583.1__= Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Content-Description: HTML

As you can see in the manual (http://www.postgresql.or= g/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 <=3D 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" <ezequias@fastcon.com.br>= ; 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
      &= nbsp; 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
=

--=__PartFBDF4583.1__=--