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" <[EMAIL PROTECTED]> 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 2: Don't 'kill -9' the postmaster
