Re: Outer joins as extras()

2006-08-24 Thread Alan Green
On 8/22/06, Russell Keith-Magee <[EMAIL PROTECTED]> wrote: > On 8/22/06, Alan Green <[EMAIL PROTECTED]> wrote: > > Has anybody found a way to add an table to query with an outer join? > It isn't really a documented feature, and I haven't worked through the > details (so you will need to do a litt

Re: Outer joins as extras()

2006-08-21 Thread Russell Keith-Magee
On 8/22/06, Alan Green <[EMAIL PROTECTED]> wrote: Hi,Has anybody found a way to add an table to query with an outer join? Anybody got a different way to do it?It isn't really a documented feature, and I haven't worked through the details (so you will need to do a little code spelunking by yourself)

Outer joins as extras()

2006-08-21 Thread Alan Green
Hi, Has anybody found a way to add an table to query with an outer join? I tried the Obvious Thing: queryset = Reader.objects.all().extras( select = {'other_name': 't.name'}, tables = ["left outer join other_table t on t.id = hr_reader.other_id"])) That results in the database complaini