Thread: PL/pgSQL, RETURN NEXT, ORDER

Hi,

When I call a PL/pgSQL function that looks roughly like the following:

...
FOR x IN SELECT ... ORDER BY ... LOOPRETURN NEXT x;
END LOOP;
RETURN;
END;

Is the order of the rows guaranteed to be preserved?

Thanks.

-- 
Markus Bertheau <twanger@bluetwanger.de>

В Втр, 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 Bertheau <twanger@bluetwanger.de>