I am not in front of a sqlite equipped system at the moment, but wouldn't something like this probably work?
select * from (values ...) order by ... On Thu, Jan 30, 2014 at 1:28 PM, Zsbán Ambrus <amb...@math.bme.hu> wrote: > 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 > -- Scott Robison _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
