On 30 Jun 2011, at 7:28pm, Simon Gornall wrote: > I don't care if an update is made to the *value* of 'otherColumnName'. I only > care if the set-of-objects-that-would-be-returned could differ, not the > properties of those objects.
Do a SELECT group_concat(rowid) WHERE … when you do your original fetch and when you want to do the check, and compare the two results. The answer returned is just one long string so all you need is a routine to compare the two strings and see if they're equal. SQLite is extremely efficient at this stuff, and you're unlikely to be able to improve on it for your purposes without writing your own database system from the ground up. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
