The future release sqlite 3.8.3 adds VALUES statements as a shortcut form of SELECT statements. This shortcut simply creates a results set made of any number of rows, any number of (unnamed) columns in each, and all the values given by separate explicit expressions.
My question is whether sqlite guarantees that the order of result rows from such a statement is the same as the order they are listed in the statement. The docs at "http://www.sqlite.org/draft/lang_select.html" seem to imply that the order is undefined, the engine is free to choose whatever order it wishes. Further, you can't even use an explicit ORDER BY clause on a VALUES statement. If this is the case, what's the easiest way to generate a set of fixed number of rows like VALUES does but in an order of your choice? Ambrus _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users