Strange loop

Hi,

I need some help with the function below. My intention is to hand the
content of result_store and sort it out so that I can have a complete
recordset. But for some reason result_store is returned empty. It works fine
for one row but the concatenation of result_store and result does not seem
to work.

Can some one pleas explain why?

CREATE FUNCTION f_snus()
RETURNS varchar
AS
' DECLARE
result varchar;
result_store varchar;
row record;
BEGIN
FOR row IN
SELECT snus_id, namn, betyg FROM snus ORDER BY betyg
LOOP
SELECT INTO result row.snus_id || ''\t'' || row.namn ||
''\t'' || row.betyg || ''\n'';
result_store := result_store || result;
END LOOP;
RETURN result_store;
END;
' LANGUAGE 'PLPGSQL';

Regards

Torbjörn Andersson
---------------------------------------------------
Embryo Communication phone: +46 (0) 31-774 39 11(00)
Kungsgatan 7a fax: +46 (0)31 774 07 80
S-411 19 Göteborg mobile: 0708-30 70 04
Sweden home: http://www.embryo.se/
mail: torbjorn(dot)andersson(at)embryo(dot)se
---------------------------------------------------
"Att idag tänka annorlunda än igår skiljer den vise från den envise." — John
Steinbeck