Re: Please add exists subquery to queryset api

Yes, that's the query i'd like to have. On Monday, November 10, 2014 10:38:41 PM UTC-7, Curtis Maloney wrote: > > Can you provide the "natural" SQL version you'd rather see generated? > > Something like: > > SELECT ... FROM myapp_a WHERE NOT EXISTS (SELECT 1 FROM myapp_b T1 WHERE > T1.a_id =

Re: Please add exists subquery to queryset api

Can you provide the "natural" SQL version you'd rather see generated? Something like: SELECT ... FROM myapp_a WHERE NOT EXISTS (SELECT 1 FROM myapp_b T1 WHERE T1.a_id = myapp_a.id AND T1.criteria = True) perhaps? On 11 November 2014 16:18, George Ma wrote: > Yes,

Re: Please add exists subquery to queryset api

Yes, the actual sql is very close to this one. But I just feel this approach is like a hack. Because I always have to reverse the logic first and then reverse again. Not as natural as exists subquery. On Monday, November 10, 2014 5:53:47 PM UTC-7, Curtis Maloney wrote: > > If you want to know

Please add exists subquery to queryset api

I've encountered quite a few cases where I need to write complicated queries where a exists subquery makes more sense and has better performance. So far, there's no exists subquey support in queryset api. Please add it. -- You received this message because you are subscribed to the Google