On 23 Dec 2010, at 8:19pm, Vander Clock Stephane wrote:

> in my test all the random are different ...

Can you describe what you're trying to do with that command ?  Or can anyone 
else explain to me what Stephane is trying to do ?  I don't see the point of a 
construction like this

Select
  H1.ID
from
  HASH1 H1
where
  x1_y1_min>= max((<#randomnumber>  % 255)-10,0) and
  x1_y1_max<= min((<#randomnumber>  % 255)+10,255) and
  x1_y2_min>= max((<#randomnumber>  % 255)-10,0) and
  x1_y2_max<= min((<#randomnumber>  % 255)+10,255) and
  x1_y3_min>= max((<#randomnumber>  % 255)-10,0) and
  x1_y3_max<= min((<#randomnumber>  % 255)+10,255) and
  x1_y4_min>= max((<#randomnumber>  % 255)-10,0) and
  x1_y4_max<= min((<#randomnumber>  % 255)+10,255) and
  x1_y5_min>= max((<#randomnumber>  % 255)-10,0) and
  x1_y5_max<= min((<#randomnumber>  % 255)+10,255);
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to