gistfile1.txt

Rails database adapter issue: Postgres vs SQLite and BETWEEN

"Foo.where(:date=>(d..d))" in Postgres => finds records spanning the date
"Foo.where(:date=>(d..d))" in SQLite   => finds nothing

This is an inclusive/exclusive ambiguity in BETWEEN which Rails doesn't resolve