Re: [web2py] Re: postgress outer join

2011-05-01 Thread Pawel Jasinski
hi Massimo, how about the following: the _select/select would accept extra parameter 'inner_join' with syntax/semantic analog to 'left', but emit JOIN at the sql level. In case of such a unpleasant query as mine, it would be possible to construct it with inner_join instead of the usual way. My o

Re: [web2py] Re: postgress outer join

2011-04-29 Thread Pawel Jasinski
hi, somehow I am getting way to many records as a result. --pawel On Fri, Apr 29, 2011 at 3:53 PM, Massimo Di Pierro wrote: > Can you please try: > > db(db.first.id.belongs(db()._select(db.second.r12_first_id))) > .select(db.first.ALL,db.second.ALL,db.third.ALL,db.fourth.ALL, > left= [ > db.s