I found out that it's only redundant if you interpret the Green house-White house rule as adjacent to one another (which is a perfectly reasonable interpretation), instead of the Green house simply being anywhere to the left of the White. I tested both variations, and discovered that disabling Water/Blend will generate more answers than if it was enabled.

EDIT: Oh, sorry, this link has solutions to the puzzle, but not SQL solutions to the puzzle. Now I'm confused. The solution to the puzzle is no secret, right? It's just SQL solutions we're not supposed to post, right?

No problem, I figured most people would look up the solution anyway, just to make sure they were on the right track.

I did like this part very much:

quote:Without making these initial assumptions, I don't think you can logically deduce the answer to the puzzle, but would just need a computer to do an exhaustive search of all the possibilities. That might even come up with several valid answers!

...which is EXACTLY what I was hoping people would discover (and they did!)

I can't wait to see the answers to this. I think I was close, but I didn't get to complete it. Every time I get a little cocky and feel like I know a little something about SQL I come out here and then feel the need to crawl back into my crib....