Postgres Pro
Downloads
Home   >   mailing lists

PL/pgSQL, RETURN NEXT, ORDER - Mailing list pgsql-sql

From Markus Bertheau
Subject PL/pgSQL, RETURN NEXT, ORDER
Date
Msg-id 1097587488.2649.28.camel@dicaprio.akademie1.de
Whole thread Raw
Responses Re: PL/pgSQL, RETURN NEXT, ORDER
List pgsql-sql
Tree view 
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>

pgsql-sql by date:

Previous
From: Gerald.Laurent@bull.net
Date:
Subject: Information about the command SQL " create synonym".
Next
From: Markus Bertheau
Date:
Subject: Re: PL/pgSQL, RETURN NEXT, ORDER