Unfortunately while this is possible, it is very inefficient. It is still creating all the intermediate objects and discarding them. It may consume CPU and RAM.
You want this: db(db.entities.type==5).select(db.entities.id, processor=lambda *a,**b:[i[0] for i in a[0]]) This is as fast as it gets On Monday, 17 July 2017 14:33:17 UTC-5, Marcelo Huerta wrote: > > > El viernes, 14 de julio de 2017, 12:56:57 (UTC-3), Leonel Câmara escribió: >> >> The cleanest way is the little known and undocumented column: >> >> db(db.entities.type==5).select(db.entities.id).column() >> >> > This needs to be added to the book... > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
