List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:October 11 2011 6:13pm
Subject:Re: Inconsistent query result.
View as plain text  
----- Original Message -----
> From: "Paul Halliday" <paul.halliday@stripped>
> 
> Is it OK to keep adding to those joins? In a view there could be say
> 50 countries. The user can keep on adding more to exclude. So would I
> just expand on the ANDs like so:
> 
> AND map1.cc !='CA' AND map1.cc !='US' AND map1.cc !='LV'... ?

Yes, although "not in ()" is probably going to look a bit more manageable.

I'm also not a big fan of putting where predicates in the join clause - it's a dirty trick
- although in some cases it does shave quite a bit off the execution time.

-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
Thread
Inconsistent query result.Paul Halliday11 Oct
  • Re: Inconsistent query result.Peter Brawley11 Oct
    • Re: Inconsistent query result.Paul Halliday11 Oct
      • Re: Inconsistent query result.Johan De Meersman11 Oct
      • Re: Inconsistent query result.Peter Brawley11 Oct