On Fri, May 01, 2009 at 01:49:55PM -0700, jrs_66 wrote: > On May 1, 2:03 pm, Malcolm Tredinnick wrote: > > So what's the model-related situation where a case-statement is > > going to be necessary? I know some exist, but I'm interested in > > which particular problem you're trying to solve so that we can > > help with a solution that fits well with Django. [snip]
> > So what is the specific problem you are trying to solve that > > requires explicitly specifying an outer join? Once again, > > details will help us to help you. [snip] > > What is the specific problem area you are working in that is > > routinely returning duplicate entries and where distinct() isn't > > solving the problem? [snip] > > > The ORM seems to inevitably produce some seriously sloppy SQL > > > under the covers. > > > > Concrete details are appreciated. I would dispute your claim, by > > the way, so what are the models you're using and the querysets > > you're constructing? [snip] > Thanks! Very helpful! > > Any idea where a very experienced SQL coder can find a few details > beyond the three pages of model/queryset documentation? Such as > information on a) SQL CASE statements (or equivalent), b) > performing LEFT JOINs (or equivalent). Would studying the source > code be my best option? Malcom generously offered to assist you and posed some followup questions which you have seemingly ignored. If you're unwilling to engage in this discussion, you're wasting lots of other people's time. If you want to get the assistance you seek, it would behoove you to provide the information that was requested. Also, although reasonable people disagree over whether top-posting or bottom-posting is preferable, it's always bad form to mix the two. You did so in your reply. Additionally, in a conversation such as this, top-posting as you did tends to result in information being lost -- as it seems to have been here. If you're unfamiliar with these concepts, the following information will surely be of use to you: * <http://en.wikipedia.org/wiki/Posting_style#Inline_replying> * <http://catb.org/jargon/html/T/top-post.html> * <http://www.faqs.org/rfcs/rfc1855.html> * <http://www.caliburn.nl/topposting.html> -- Phil Mocek --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
