[Gerry Snyder] > At worst you could use another table to keep track of the maximum and > minimum, and update it with triggers when something is added to or deleted > from the virtual table.
My module knows what the maximum and minimum values are at all times. It also knows that the column is sorted. The trouble is that it doesn't know that the values it can produce for that column will be fed to a max() and min() function. If it did, it could simply just return one value. I might be missing something, though. -- Steinar _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users