it may help knowing what are you trying to count (e.g. write down the plain sql syntax you'd like to fire, or explain with a sample table what resultset you expect)
On Friday, December 14, 2012 1:01:37 AM UTC+1, Manuele wrote: > > Hi! > trying this simple query I got this error: > > ipdb> db(query)._count(distinct=fields) > "SELECT count(DISTINCT vista.municipio, vista.quartiere, vista.desvia, > vista.den_tot, vista.den_predatori, vista.den_confl, vista.den_dann) > FROM vista WHERE ((vista.id > 0) AND (vista.quartiere = '22: S. > Martino'));" > > ipdb> db(query).count(distinct=fields) > *** ProgrammingError: function count(character varying, character > varying, character varying, integer, integer, integer, integer) does not > exist > LINE 1: SELECT count(DISTINCT vista.municipio, vista.quartiere, vist... > ^ > HINT: No function matches the given name and argument types. You might > need to add explicit type casts. > > did I make errors somewhere? > > thanks a lot > Cheers > > Manuele > --
