loop query results - Mailing list pgsql-sql

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

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 6Xecht_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