Wells Oliver <wells.oliver@gmail.com> 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