Re: Concatenating several rows with a semicolon

[Alexander Farber <alexander.farber@xxxxxxxxx>]

I'm trying:

create or replace function pref_money_stats(_id varchar)
        returns varchar as $BODY$
        begin

        declare stats varchar;

        for row in select yw, money from pref_money where id=_id order
by yw desc limit 20 loop
                stats := stats || ";" || row.id || ":" || row.money;
        end loop;

        return stats;
        end;
$BODY$ language plpgsql;

but get the error:

ERROR:  syntax error at or near "for"
LINE 7:         for row in select yw, money from pref_money where id...
                ^

Regards
Alex

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general