Sort stability: Difference between revisions

Content added Content deleted
(added sort by rowid to enforce a stable sort)
m (added a comma)
Line 330: Line 330:


=={{header|OpenEdge/Progress}}==
=={{header|OpenEdge/Progress}}==
The results can be forced to stable by ''additionally'' sorting on the ROWID of the record. If you leave the additional sort out the indexes on the temp-table can influence the result.
The results can be forced to stable by ''additionally'' sorting on the ROWID of the record. If you leave the additional sort out, the indexes on the temp-table can influence the result.
<lang progress>DEFINE TEMP-TABLE tt
<lang progress>DEFINE TEMP-TABLE tt
FIELD country AS CHAR FORMAT 'x(2)'
FIELD country AS CHAR FORMAT 'x(2)'