On Sat, Apr 2, 2011 at 8:01 PM, Matt Young <[email protected]> wrote:
> sqlite> select 1 as type union select 2; > type > 1 > 2 > sqlite> select 'tr' as type union select 2; > type > 2 > tr > sqlite> > > The order of the rows change when text replaces a numeric. > My understanding is that if you don't use an ORDER BY clause, you're asking for an unordered set. So SQLite can print your result set in whatever order it likes. Eric _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
