1. I try to select: sqlite> select save_date from photo_tags where save_date<2454612.21079943 limit 1 offset 3073; save_date = 2454612.21079943
But 2454612.21079943<2454612.21079943 is wrong result. 2. And I try sqlite> select save_date from photo_tags where save_date=2454612.21079943; sqlite> So, sqlite calculate 2454612.21079943!=2454612.21079943 3. And this query working correctly: sqlite> select save_date from photo_tags where save_date=(select save_date from photo_tags where save_date<2454612.21079943 limit 1 offset 3073); save_date = 2454612.21079943 Table is like CREATE TABLE photo_tags ( save_date REAL, ... ); _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
