> As this applies to my query, it would be: > SELECT * FROM Words > GROUP BY Id, Lang, Rev > HAVING Rev=Max(Rev)
Drat. That Rev shouldn't be in the GROUP BY. The query I wanted to write is: SELECT * FROM Words GROUP BY Id, Lang HAVING Rev=Max(Rev) > Given that I have my Primary Key as (Id, Lang, Rev) > it is (at least in theory) deducable by the database that > each equivalence class is reduced to size 1 > > So the question is, would it make sense to suggest > that SQLite take a member of the equivalence class > when non GROUP BY fields are selected without > aggregate functions or has this already been > discussed and rejected? As far as I can see, there > is no backwards compatibility issue. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users