Wells Oliver <wells.oliver@xxxxxxxxx> writes: > Is there a meaningful difference index/plan-wise searching where DATE > BETWEEN x AND y versus DATE >= x AND DATE <= y? Nope. > Secondly, would btree be the best index for such a column, or gist/etc? btree. gist can sort of do scalar-inequality searches, but they're not its strength. regards, tom lane
