Re: Problems searching ranges of values with double datatype

2009-04-30 Thread Iris Soto
Iris Soto escribió: Iris Soto escribió: Hi all, I am having problems with search for double datatype, for example: I'm testing comparing results of search in a range of "0 TO 1000", with the result of the sum from searches between ranges "0 TO 500" and "501 TO 1000" and there are diferent r

Re: Problems searching ranges of values with double datatype

2009-04-30 Thread Koji Sekiguchi
Use sdouble instead of double for range queries since the lexicographic ordering isn't equal to the numeric ordering. Koji Iris Soto wrote: Iris Soto escribió: Hi all, I am having problems with search for double datatype, for example: I'm testing comparing results of search in a range

Re: Problems searching ranges of values with double datatype

2009-04-30 Thread Iris Soto
Iris Soto escribió: Hi all, I am having problems with search for double datatype, for example: I'm testing comparing results of search in a range of "0 TO 1000", with the result of the sum from searches between ranges "0 TO 500" and "501 TO 1000" and there are diferent results. I've read tha

Problems searching ranges of values with double datatype

2009-04-30 Thread Iris Soto
Hi all, I am having problems with search for double datatype, for example: I'm testing comparing results of search in a range of "0 TO 1000", with the result of the sum from searches between ranges "0 TO 500" and "501 TO 1000" and there are diferent results. I've read that the correct datatyp

Problems searching ranges of values with double datatype

2009-04-30 Thread Iris Soto
Hi all, I am having problems with search for double datatype. I'm testing comparing this result with sum of results of searches of ranges "0 TO 500" and "501 TO 1000" and there are diferent results. I've read that the correct datatype for money fields is double but something is not working