loop query results

With the following function I expected to get an iteration through the results. But the loop seems to be performed two times instead.

The function (postgres 7.2):

create function echt_char_laenge ()
returns integer
as

'
declare
char_auslese record;

begin
for char_auslese in select * from varlaenge loop
raise notice ''%, %'', char_auslese.id_var, char_auslese.var_text;
end loop;

return 0;
end;
'
language 'plpgsql';

------------------------------------------------------------

the result:

select echt_char_laenge ();

NOTICE: 1, text 1X
NOTICE: 2, text 2X
NOTICE: 3, text 3X
NOTICE: 4, text 4X
NOTICE: 5, text 5X
NOTICE: 6, text 6X
NOTICE: 1, text 1X
NOTICE: 2, text 2X
NOTICE: 3, text 3X
NOTICE: 4, text 4X
NOTICE: 5, text 5X
NOTICE: 6, text 6X
echt_char_laenge
------------------
0
(1 row)

----------

and the result as expected:

select * from varlaenge;

id_var | var_text
--------+-------------
1 | text 1X
2 | text 2X
3 | text 3X
4 | text 4X
5 | text 5X
6 | text 6X
(6 rows)

Any ideas?

Thanx
Stefan

______________________________________________________________________________
Schneller als andere! Die Blitz-SMS von WEB.DE FreeMail!
http://freemail.web.de/features/?mc=021167