At 2012-10-21 14:27:39 -0400, tgl(at)sss(dot)pgh(dot)pa(dot)us wrote:
>
> Is that fundamentally an illegitimate optimization, and if so why?
I wouldn't say it's illegitimate. It's a bit less convenient for the
application programmer, and will surprise some people (even some who
know better than to expect SELECT to produce a particular row order).
That's all.
-- Abhijit