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.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to