On Wed, 27 Aug 2014 23:04:40 +0200 Petite Abeille <petite.abei...@gmail.com> wrote:
> > On Aug 27, 2014, at 10:57 PM, Eduardo Morras <emorr...@yahoo.es> > wrote: > > > Sorry, don't understand why others will throw an exception in the > > group by, perhaps I'm misunderstanding the group by, but that > > should work on others engines. > > Because not all expressions are accounted for, i.e.: > > "not a GROUP BY expression > > Cause: The GROUP BY clause does not contain all the expressions in > the SELECT clause. SELECT expressions that are not included in a > group function, such as AVG, COUNT, MAX, MIN, SUM, STDDEV, or > VARIANCE, must be listed in the GROUP BY clause. > > Action: Include in the GROUP BY clause all SELECT expressions that > are not group function arguments.” Yep, it's true, I didn't notice it and asked too early. > > Try it. See what happen. It bangs, as expected, in PostgreSQL 9.2, adding the other selects columns solves it. Thanks. --- --- Eduardo Morras <emorr...@yahoo.es> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users