> This query returns a boolean result and stops as soon as it has > determined the result
> select exists (select * from contacts where contacts_phone_tel glob ?); > HTH > Dennis Cote I have been using: SELECT NULL FROM sqlite_master WHERE type='table' AND lower(name)=? to determine whether a table exists and looking at the number of rows returned (I'm using sqlite3_get_table through an API). I get one row back if the table exists and no rows when it doesn't. There wouldn't be multiple rows to LIMIT in this case though. Is that bad? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
