PL/pgSQL, RETURN NEXT, ORDER

From: Markus Bertheau <twanger(at)bluetwanger(dot)de>
To: "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org>
Subject: PL/pgSQL, RETURN NEXT, ORDER
Date: 2004-10-12 13:24:48
Message-ID: 1097587488.2649.28.camel@dicaprio.akademie1.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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 <twanger(at)bluetwanger(dot)de>

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Markus Bertheau 2004-10-12 13:41:15 Re: PL/pgSQL, RETURN NEXT, ORDER
Previous Message Gerald.Laurent 2004-10-12 13:04:14 Information about the command SQL " create synonym".