but that defeats the purpose if I order by all the fields. I've been trying for hours now get the correct way of grouping by ( groupby table.field ) in postgresql. Any help?
On Thursday, June 26, 2008 3:35:50 PM UTC+2, Massimo Di Pierro wrote: > > (a==1)|(b==2) is translated in "(a=1) OR (b=2)" > > but > > a|b is translated in "a, b" > > so you can do orderby=db.table.field|db.table.otherfield > > Massimo > > > On Jun 26, 2008, at 8:33 AM, voltron wrote: > > > > > Can you please give me an example? I am confuesd because its not a > > logical OR, its a Postgres thing > > > > > > Thanks > > > > On Jun 26, 3:30 pm, Massimo Di Pierro <mdipie...@cs.depaul.edu> wrote: > >> You should be able to use the "|" operator > >> > >> On Jun 26, 2008, at 2:47 AM, voltron wrote: > >> > >> > >> > >>> PostgreSQL is very picky when using something like "groupby" How > >>> doe I > >>> pass multiple values to the groupby attribute in web2pys ORM select > >>> function? > >> > >>> I get this: > >> > >>> self._execute=lambda *a,**b: self._cursor.execute(*a,**b) > >>> ProgrammingError: column "user_logs.id" must appear in the GROUP BY > >>> clause or be used in an aggregate function > >> > >>> thanks > > > > > -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
