From: Torbjörn Andersson <tobbe@embryo.se>
To: pgsql-sql@postgresql.org
Subject: Strange loop
Date: Tue, 30 Oct 2001 22:05:15 +0100
Message-ID: <B804D49A.1266%tobbe@embryo.se> (raw)
In-Reply-To: <20011031025141.402B.RK73@echna.ne.jp>
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.andersson@embryo.se
---------------------------------------------------
"Att idag tänka annorlunda än igår skiljer den vise från den envise." — John
Steinbeck
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tobbe@embryo.se
Subject: Re: Strange loop
In-Reply-To: <B804D49A.1266%tobbe@embryo.se>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox