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