Can we not add per-dialect identifiers to DAL... I can see adding this just for postgres & ms sql.
-- Thadeus On Fri, Jan 28, 2011 at 8:43 AM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > This is not supported because I am not sure all supported RDBS support > count(distinct ...). > > As a way around it you can do > > len(db().select(db.item.of_variant,distinct=True)) > > Massimo > > On Jan 28, 6:32 am, vortex <billyara...@gmail.com> wrote: > > How to do a count distinct with DAL? > > > > like: > > > > db().count(db.item.of_variant, distinct=True) >