cursors
Hello every one.
im trying to make a Loop and i found in the manual this.
FOR <target> IN <query> LOOP
<statements>
END LOOP
Can i use cursor instead of the Query in the loop?? ,
this es more legible than using the open/fetch/close of the cursor.
Regard Cesar Alvarez.
On 24/11/2007, Cesar Alvarez <c.alvarezx66@gmail.com> wrote:
Hello every one.
im trying to make a Loop and i found in the manual this.FOR <target> IN <query> LOOP
<statements>
END LOOPCan i use cursor instead of the Query in the loop?? ,
this es more legible than using the open/fetch/close of the cursor.Regard Cesar Alvarez.
Hello
FOR statement use cursor internally. If you wont to use cursor
explicitly, you have to use WHILE loop.
Regards
Pavel Stehule
Show quoted text
---------------------------(end of
broadcast)---------------------------
TIP 6: explain analyze is your friend
Thanks,
what will be the syntax for that type of for?
Pavel Stehule wrote:
Show quoted text
On 24/11/2007, Cesar Alvarez <c.alvarezx66@gmail.com> wrote:
Hello every one.
im trying to make a Loop and i found in the manual this.FOR <target> IN <query> LOOP
<statements>
END LOOPCan i use cursor instead of the Query in the loop?? ,
this es more legible than using the open/fetch/close of the cursor.Regard Cesar Alvarez.
Hello
FOR statement use cursor internally. If you wont to use cursor
explicitly, you have to use WHILE loop.Regards
Pavel Stehule---------------------------(end of
broadcast)---------------------------
TIP 6: explain analyze is your friend
On 24/11/2007, Cesar Alvarez <c.alvarezx66@gmail.com> wrote:
Thanks,
what will be the syntax for that type of for?
DECLARE
curs2 CURSOR FOR SELECT * FROM tenk1;
c1 integer;
c2 integer;
BEGIN
OPEN curs2;
FETCH curs2 INTO c1,c2;
WHILE found LOOP
...
FETCH curs2 INTO c1,c2;
END LOOP;
CLOSE curs2;
Regards
Pavel Stehule
Show quoted text
Pavel Stehule wrote:
On 24/11/2007, Cesar Alvarez <c.alvarezx66@gmail.com> wrote:Hello every one.
im trying to make a Loop and i found in the manual this.FOR <target> IN <query> LOOP
<statements>
END LOOPCan i use cursor instead of the Query in the loop?? ,
this es more legible than using the open/fetch/close of the cursor.Regard Cesar Alvarez.
Hello
FOR statement use cursor internally. If you wont to use cursor
explicitly, you have to use WHILE loop.Regards
Pavel Stehule---------------------------(end of
broadcast)---------------------------
TIP 6: explain analyze is your friend