2010/6/11 Igor Tandetnik <itandet...@mvps.org>: > Well, many SQL engines, as well as SQL-92 standard, do prohibit such a > syntax. According to the standard, in a statement using GROUP BY, any column > reference that appears in SELECT clause must also appear in GROUP BY clause > or be part of an argument of an aggregate function. SQLite allows "naked" > non-grouped columns as an extension (which is occasionally useful).
This is needed as replacement of the "distinct on" clause. I don't know other way to translate many queries from PostgreSQL to SQLite. -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
