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 regards, 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 regards, 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 an argument of an aggre
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 group by clause?A
4 matches
Mail list logo