On Sat, Feb 17, 2007 at 03:02:06PM +0530, Rajesh Kumar Mallah wrote:
>
> select id , name , expensive_func(name) from
> ( select id , name from tab order by c1 desc limit 15) as foo ;
>
> is it guaranteed that the final result is order by c1 ?
No, because expensive_func(name) might do something that alters it,
no? All things considered, it's a pretty good _bet_ it will be
ordered as you wish, though.
A
--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
The whole tendency of modern prose is away from concreteness.
--George Orwell