> Behalf Of Richard Hipp
> > And also the meaning/use of
> SQLITE_INDEX_CONSTRAINT_FUNCTION, that would be
...
> The SQLITE_INDEX_CONSTRAINT_FUNCTION mechanism was added to support
> the new Geopoly extension, and the ability to index on things like
> "WHERE geopoly_within(_shape,...)" and "WHERE
On 10/16/18, dave wrote:
>
> And also the meaning/use of SQLITE_INDEX_CONSTRAINT_FUNCTION, that would be
> super helpful.
>
The SQLITE_INDEX_CONSTRAINT_FUNCTION mechanism was added to support
the new Geopoly extension, and the ability to index on things like
"WHERE geopoly_within(_shape,...)" and
> Behalf Of Keith Medcalf
> Sent: Saturday, October 13, 2018 6:53 PM
...
>
> > Lastly, I'm assuming that 'IS' and 'IS NOT' is functionally
> > equivalent to the '=' and '<>' operators?
> > Or is there some subtle difference
>
> As long as neither the LHS or the RHS are null, then IS and
> IS
> Lastly, I'm assuming that 'IS' and 'IS NOT' is functionally
> equivalent to the '=' and '<>' operators?
> Or is there some subtle difference
As long as neither the LHS or the RHS are null, then IS and IS NOT are the same
as == and <> respectively.
However, if you use the "comparison" opera
at all.
Cheers!
-dave
> -Original Message-
> From: sqlite-users
> [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
> Behalf Of dave
> Sent: Monday, September 24, 2018 2:57 PM
> To: 'SQLite mailing list'
> Subject: Re: [sqlite] [EXTERNAL] virtual tab
t; Behalf Of Hick Gunter
> Sent: Monday, September 24, 2018 1:57 AM
> To: 'SQLite mailing list'
> Subject: Re: [sqlite] [EXTERNAL] virtual tables, xBestIndex,
> pIdxInfo->aConstraint[].op, and 'NOT'...
>
>
> Which version are you using? The set of cons
Which version are you using? The set of constraint constants was extended in
versions 3.10 (LIKE, GLOB, REGEXP), 3.21 (NE, IS*) and most recently 3.25
(FUNCTION)
-Ursprüngliche Nachricht-
Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im
Auftrag von dave
Gesende
7 matches
Mail list logo
