Re: [SQL] PL/pgSQL, RETURN NEXT, ORDER

2004-10-12 Thread Markus Bertheau
Ð ÐÑÑ, 12.10.2004, Ð 15:24, Markus Bertheau ÐÐÑÐÑ: > Is the order of the rows guaranteed to be preserved? Neil clarified on IRC that - there is no interface guarantee - in the current implementation the order is preserved - a future implementation is likely to change that Thanks. -- Markus Ber

[SQL] PL/pgSQL, RETURN NEXT, ORDER

2004-10-12 Thread Markus Bertheau
Hi, When I call a PL/pgSQL function that looks roughly like the following: ... FOR x IN SELECT ... ORDER BY ... LOOP RETURN NEXT x; END LOOP; RETURN; END; Is the order of the rows guaranteed to be preserved? Thanks. -- Markus Bertheau <[EMAIL PROTECTED]> ---(