My apologies if this is stupid, or it's already been discussed. There's a way of choosing an ordering on anything, even strings.
Have two tables - one where members of column A are "larger", one where members of column B are "larger". Only insert into the correct table (O(1) operation). Insert with a time and when doing the select choose the earlier time. Ian _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
