]> granicus.if.org Git - postgresql/commit
Tweak recognition of range-clause pairs so that 'var > $1 AND var < $2'
authorTom Lane <tgl@sss.pgh.pa.us>
Wed, 31 May 2000 15:38:53 +0000 (15:38 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Wed, 31 May 2000 15:38:53 +0000 (15:38 +0000)
commitcbf503180fda16cd4688ddfa67b6ea2b6eafef25
tree3592df3d277383ce2cff38047647103decc3bfd3
parent6a68f42648f54690ad5b5ae6fb9104e86e15f0f1
Tweak recognition of range-clause pairs so that 'var > $1 AND var < $2'
(ie, parameters instead of consts) will be treated as a range query.
We do not know the actual selectivities involved, but it seems like
a good idea to use a smaller estimate than we would use for two unrelated
inequalities.
src/backend/optimizer/path/clausesel.c