>>>> 2012/11/04 22:23 +0000, Stefan Kuhn >>>>
select * from table order by udf(column, 'input_value') desc;
For my understanding, this should give the same result always. 
<<<<<<<<
But if for your data function "udf" returns the same for more arguments there 
is not enough to fix the order. In that case I have found that other accidental 
things affect the order, things that one would not suspect: howmuch store is 
used and needed for the ordering, ... a further reason for showing what the 
function returns. If the order varies, although the function returns the same 
in all cases, well, ....


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql

Reply via email to