On Nov 23, 2011, at 6:05 PM, Pavel Ivanov wrote: >> Well, if this is about Alice in Wonderland, then, what about: >> >>> select max( 1 ) from t order by avg( a ); >> 1 > > Well, apparently you did this on non-empty table. This query gives > different and kind of unexpected result on empty table. ;)
Well, it returns null, no? What else would you expect? Getting deeper and deeper in the rabbit hole... :)) _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users