Re: [sqlite] SQLite lets selecting a column that is not inthe Group by clause

2010-06-14 Thread Alexey Pechnikov
And this is needed as replacement of the "distinct on" clause. I don't know other way to translate many queries from PostgreSQL to SQLite. 2010/6/11 Igor Tandetnik : > SQLite allows "naked" non-grouped columns as an extension (which is > occasionally useful). -- Best

Re: [sqlite] SQLite lets selecting a column that is not inthe Group by clause

2010-06-14 Thread Alexey Pechnikov
2010/6/11 Igor Tandetnik : > SQLite allows "naked" non-grouped columns as an extension (which is > occasionally useful). And 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

Re: [sqlite] SQLite lets selecting a column that is not inthe Group by clause

2010-06-11 Thread Alexey Pechnikov
2010/6/11 Igor Tandetnik : > 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

Re: [sqlite] SQLite lets selecting a column that is not inthe Group by clause

2010-06-11 Thread Igor Tandetnik
Jay A. Kreibich wrote: > On Fri, Jun 11, 2010 at 11:30:43AM +0200, Benoit Mortgat scratched on the > wall: > >> select col1, col2 from foo group by col1; >> >> As you can see, that last query does not result in any error, however >> col2 should not be selectable if not in the