On Mon, Sep 22, 2008 at 12:17:44PM +1000, BareFeet wrote:
> select exists (select 1 from MyTable where condition)
>
> which will return a boolean result, and stop scanning the table after
> the first match is found.
Yes, thanks - that's right: it is partial solution indeed. "Partial" -
because in the case of non-existence it has to scan the table to the end
anyway.
But still it's better than "count(*)".
--
pozdrawiam / regards
Zbigniew Baniewski
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
