order by in for loop in plpgsql does not work - Mailing list pgsql-general

Any idea why when I call this function the record are not processed in
the order requested?

JLL

P.S.

It would be nice if the syntax would allow me to write something like >>
cur.seqno = seq
and have the underlying record updated.



declare

cur record;
seq int;
exchangeno text;
routeno text;

begin

exchangeno := '';
routeno := '';

for cur in
    select oid, * from r order by exchangeno, routeno, street,
municipality, parity desc, fromno for update
loop
    if cur.exchangeno != exchangeno or cur.routeno != routeno
    then
        seq := 1;
        exchangeno := cur.exchangeno;
        routeno := cur.routeno;
    end if;
    update r set seqno = seq, route = routeno || trim( lpad( seq, 4, '0'))
where oid = cur.oid;
    seq := seq + 1;
end loop;

return 0;
end;