Re: [web2py] concatenating strings in group by select

db.executesql(your_sql_statement) should work, I guess. Kiran Subbaraman http://subbaraman.wordpress.com/about/ On Thu, 04-06-2015 8:06 PM, Yebach wrote: Hello I have the following SQL for PostgreSQL select rw_worker , rw_date , array_to_string(array_a

[web2py] concatenating strings in group by select

Hello I have the following SQL for PostgreSQL select rw_worker , rw_date , array_to_string(array_agg(distinct results_woshi.rw_shift),'&') AS shifts from results_woshi where rw_date > '2015-01-01' and rw_script = 42 group by rw_worker, rw_date order by rw_date The result is 49;"2015-05-01