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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
