>
> OK, there is no requirement, but there is a wish to return a stable
> sorting outcome.
Just add an 'order by' clause.
> Please note that the SQL standard does not prohibid stable sorting
> outcome.
It does prohibit it. It states the output is not sorted unless
you ask for it to be.
> Please also note that by adding the rowid an unstable sort-algorithm
> can produce a stable sort-outcome.
Add an 'order by' clause and a rowid to your select.
__________________________________
Do you Yahoo!?
Yahoo! Personals - Better first dates. More second dates.
http://personals.yahoo.com