From: Bart Degryse <Bart.Degryse@indicator.be>
To: pgsql-sql@postgresql.org
Cc: Ezequias R. da Rocha <ezequias@fastcon.com.br>
Subject: Re: For loop
Date: Tue, 13 Mar 2007 14:41:13 +0100
Message-ID: <45F6B808.A3DD.0030.0@indicator.be> (raw)
In-Reply-To: <45F6A793.1090904@fastcon.com.br>
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>
<45F6B 4EB.A3DD.0030.0@indicator.be>
<45F6A793.1090904@fastcon.com.br>
AFAK you can also use them in eg CREATE TRIGGER and on the psql command prompt.
What are you trying to accomplish. When we understand that, maybe we can point you in the right direction.
>>> "Ezequias R. da Rocha" <ezequias@fastcon.com.br> 2007-03-13 14:30 >>>
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
> <mailto:pgsql-sql@postgresql.org>
>
> >>> "Ezequias R. da Rocha" <ezequias@fastcon.com.br> 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" <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
> > 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
>
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: Bart.Degryse@indicator.be, ezequias@fastcon.com.br
Subject: Re: For loop
In-Reply-To: <45F6B808.A3DD.0030.0@indicator.be>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox