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

Reply via email to