Does your dbms support count(distinct ....) ? What happens if you only put one column in COUNT(DISTINCT vista.municipio) ?
On Friday, December 14, 2012 1:13:32 PM UTC+13, Niphlod wrote: > > 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 >> > --
