pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

PL/pgSQL, RETURN NEXT, ORDER
2+ messages / 1 participants
[nested] [flat]

* PL/pgSQL, RETURN NEXT, ORDER
@ 2004-10-12 13:24 Markus Bertheau <twanger@bluetwanger.de>
  2004-10-12 13:41 ` Re: PL/pgSQL, RETURN NEXT, ORDER Markus Bertheau <twanger@bluetwanger.de>
  0 siblings, 1 reply; 2+ messages in thread

From: Markus Bertheau @ 2004-10-12 13:24 UTC (permalink / raw)
  To: 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@bluetwanger.de>




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: PL/pgSQL, RETURN NEXT, ORDER
  2004-10-12 13:24 PL/pgSQL, RETURN NEXT, ORDER Markus Bertheau <twanger@bluetwanger.de>
@ 2004-10-12 13:41 ` Markus Bertheau <twanger@bluetwanger.de>
  0 siblings, 0 replies; 2+ messages in thread

From: Markus Bertheau @ 2004-10-12 13:41 UTC (permalink / raw)
  To: pgsql-sql

В Втр, 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>




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2004-10-12 13:41 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-10-12 13:24 PL/pgSQL, RETURN NEXT, ORDER Markus Bertheau <twanger@bluetwanger.de>
2004-10-12 13:41 ` Markus Bertheau <twanger@bluetwanger.de>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox