2009/7/20 Robert James <srobertja...@gmail.com> > > Hi. I notice that when I do a WHERE x, Postgres uses an index, and when I > do WHERE y, it does so as well, but when I do WHERE x OR y, it doesn't. Why > is this so?
It's not clever enough. And how can I shut this off? Use UNION/UNION ALL if possible in your case.