On Sun, Sep 20, 2015 at 5:18 PM, Simon Slavin <slavins at bigfraud.org> wrote:

>
> On 20 Sep 2015, at 11:59pm, Keith Medcalf <kmedcalf at dessus.com> wrote:
>
> > The RowID is an integer.  It is perfectly possible to have RowID's with
> a value less than 0.
> >
> > sqlite> create table x(x);
> > sqlite> insert into x (rowid, x) values (-1, -1);
> > sqlite> select rowid, x from x;
> > -1|-1
>
> Yep.  But it's unlikely in a world where you allow it to be set by
> autoincrement.
>

Then just go with something like ((rowid - rowid) <> 0). The basic premise
still holds that it should be easy to come up with a condition that is
always false.

-- 
Scott Robison

Reply via email to