On 2017/09/05 10:00 PM, Stephen Chrzanowski wrote:
On behalf of Cecil, the fault in that logic is that count(*) returns the number of rows in that table, not whether there is a hole "somewhere: Your query will either return 1, or, 0.
Perhaps this is the opportune moment to learn. Test the theory in SQLite, you will see that Igor is correct (and correct for all versions of SQL, not just -lite).
_______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users