On Mon, Nov 04, 2013 at 10:44:29PM +0100, Janek Sendrowski wrote:
> I am always searching for single colums. The values are different every
> time, because these are distances from my new sentence to my pivots.
> Does the Index support a query with this WHERE statement: WHERE value BETWEEN
> (di
Janek Sendrowski wrote:
> Does the Index support a query with this WHERE statement: WHERE
> value BETWEEN (distance1 - radius) AND (distance1 + radius)?
Note that the following are all equivalent:
value BETWEEN (distance1 - radius) AND (distance1 + radius)
value >= (distance1 - radius) and val
Thanks for your Answers!
@Martijn van Oosterhout
I am always searching for single colums. The values are different every time,
because these are distances from my new sentence to my pivots.
Does the Index support a query with this WHERE statement: WHERE value BETWEEN
(distance1 - radius) AND
On Mon, Nov 04, 2013 at 07:21:11PM +0100, Janek Sendrowski wrote:
> Hi,
>
> I've got a table with many Values of the Type REAL.
> These are my metric distances or my pivots to my sentences.
> The table looks like this:
>
> ID INTEGER, distance1 REAL, distance2 REAL, distance3 REAL, distance4 REAL
Janek Sendrowski wrote:
> I've got a table with many Values of the Type REAL.
> These are my metric distances or my pivots to my sentences.
> The table looks like this:
>
> ID INTEGER, distance1 REAL, distance2 REAL, distance3 REAL,
> distance4 REAL, ..., distance24 REAL
It should always raise a
Hi,
I've got a table with many Values of the Type REAL.
These are my metric distances or my pivots to my sentences.
The table looks like this:
ID INTEGER, distance1 REAL, distance2 REAL, distance3 REAL, distance4 REAL,
..., distance24 REAL
The range of the Value is in between 0 and 1. So it loo
