Re: [web2py] Web2py Postgresql Groupby issue

2017-05-12 Thread Carlos Correia
On 11-05-2017 15:22, Oasis Agano wrote: > Hello > > i have moved my connection to Postgres from sqlite and im facing this issue; > >ret = self.get_cursor().execute(command, *a[1:], **b) > ProgrammingError: column "water_flow_log.id" must appear in the GROUP BY > clause or be used in an aggre

[web2py] Web2py Postgresql Groupby issue

2017-05-11 Thread Oasis Agano
Hello i have moved my connection to Postgres from sqlite and im facing this issue; ret = self.get_cursor().execute(command, *a[1:], **b) ProgrammingError: column "water_flow_log.id" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT water_flow_log.id, water